Hi
then you may provide some more details:
- how are your sheets exactly named
- which column to search and which to return
- can the resulting value only appear once (or could you have multiple
matches)

--
Regards
Frank Kabel
Frankfurt, Germany

Neil wrote:
Thanks Frank,

The return values are numeric....

Regards,

Neil.


"Frank Kabel" wrote in message
...
Hi
is the return value a numeric value?

"Neil" wrote:

Hi All,

How best can I do a vlookup over multiple worksheets without
resorting to a
macro ??

I have 5 sheets and the vlookup value is in one of them (not sure
which one)
so I'd like
the worksheet function to cycle through them to find the lookup
reference otherwise
through out an error message.

I have tried 'if(iserror(vlookup......' looping from sheet to sheet
but this
is painstaking and
not getting me there.

Thanks for the assistance.

Neil