Insert table_array as a Variable into VLOOKUP based on Data Validation result

Hi,

When performing a VLOOKUP I need the table_array variable to change to a different table name based on 3 options in a Data Validation cell which then performs a match inside the correct table_array.

e.g. Data Validation cell contains a drop down box with the following options: Apples, Oranges, Pears

Formula

Please Login or Register  to view this content.

The MATCH portion works as expected however I'm having trouble changing the table_array according to the drop down list.

Would prefer to keep the workbook formula based without having to use VBA if possible.

Thanks

Apologies ramananhrm,

The fix broke my MATCH statement as a cross reference which was looking up a static table which also needs to change to a variable now.

Could you have a look at the attached and show me how to do a MATCH lookup for the number of boxes please?

Many thanks ramananhrm, Greatly appreciated!

This guy knows his Excel people.

Cheers