VLOOKUP - Select a table column with a drop down list (2/2)

VLOOKUP - Select a table column with a drop down list

The following sheet let´s you select a column in the table and the the value from that column is returned.

How to create the drop down list in cell B4

1. Select cell B4
2. Go to "Data" tab
3. Click "Data Validation" button
4. Select "List" i the drop down list
5. Select source: =$C$8:$E$8
   
6. Click OK

Array formula in cell C4:

=VLOOKUP(C2, IF(Table2[Region]=C3, Table2, ""), MATCH(B4, Table2[#Headers], 0), FALSE)

becomes

=VLOOKUP(C2, IF(Table2[Region]=C3, Table2, ""), MATCH(Company Name", {"Item","Region","Company Name","First Name","Last Name"}, 0), FALSE)

becomes

=VLOOKUP(C2, IF(Table2[Region]=C3, Table2, ""), 3, FALSE)

and returns "The New Firm"