OK thanks

Is there some other formula I could use?

Shona


"Chip Pearson" wrote in message
...
You can't do that. VLOOKUP only takes a range on a single sheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"SS" wrote in message
...
Hi

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

Any ideas would be great

Thanks Shona