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