Getting cell content based on multiple columns of data (Vlookup? IndexMatch?)

You can do this with a pivot table built on the source data. Take a look at Sheet1. I suggest you reconstruct the pivot table yourself to see how it's put together. Do a web search on tabular formats. I think 2010 has that as an option although you will have to go through and turn off subtotals under Field Values.

You can use a pivot table for VLOOKUP. You can define it as a named dynamic range. In this case, I created a name Lookup_Source =OFFSET(Sheet1!$A$4,0,0,COUNTA(Sheet1!$A:$A)-1,COUNTA(Sheet1!$4:$4))

Here is more information about how to make a named dynamic range: http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges.

Then you can do things like =VLOOKUP(Value,Lookup_Source,2,False)

BTW: I managed to cut the size of the workbook from 5.5 MB to 18 KB. You got something ugly after row 49. I deleted all those rows and the workbook shrunk dramatically.

The other option, depending on what you are doing is to use INDEX and MATCH against the original source data.