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