I have a table of data. I want to match 3 criteria to the first 3 columns of the data, and return the matched data. The data is in one worksheet the results is in a second. For example
Serach criteria:
Year: 2013
Quarter: 1
Class:A

The data array has columns of Year, quarter, Class, Total Inventory, Available SF, Vacancy rate, etc.

I cannot get Vlookupor INDEX to work. Thanks.