To create a validation list with multiple columns, we'll need to trick Excel to accept to create a validation list with multiple columns Example to show the range A1 to C20 (20 rows and 3 columns).

The data has columns for the name of the resource (What), the author (Who), TheURL, Tags, Type, and Comments. Next, I want create a new column called Resource with a clickable link to each resource.

The function appends a two-column list and the {“Region”,”Amount”} array enters headings for both columns. Figure C This function has an array as the first argument.