You can have a construct like this for 3 sheets:

=IF(ISNA(vlookup1),IF(ISNA(vlookup2),IF(ISNA(vlook up3),"not
found",vlookup3),vlookup2),vlookup1)

where vlookup1 is for the first sheet, vlookup2 is for the second
sheet and vlookup3 is for the third sheet.

Hope this helps.

Pete

On Jun 30, 6:51*am, Jeremy wrote:
Hi.

I would like to use a VLOOKUP to find a value that could be in more than one
Sheet.

I can only enter the formula to show where one sheet is, not any others.

Please Help if you know what I am on about.

Thank You.