Hi

Is it possible to use VLOOKUP across a 3d range? I have six sheets in a
workbook, and on each sheet column G holds a store number. I have created a
3d range across the sheets.

I want to cross reference the data on the six sheets with a master sheet to
ensure that all the stores from the master sheet appear somewhere else in the
workbook. I've tried VLOOKUP, MATCH, INDEX and a very complicated IF function
but nothing seems to work. Any ideas?