How many sheets do you have? How are they named?

Where are your tables located? Are they all located in the same range
of cells for each sheet?

In article ,
"SS" wrote:

Hi

Anyone know if it is possible to do a vertical lookup over multiple sheets

Any ideas would be great

Thanks Shona