No. But you could look in each sheet until you find it.

=IF(NOT(ISERROR(VLOOKUP(A1,Sheet2!A:B,2,0))),VLOOK UP(A1,Sheet2!A:B,2,0),
IF(NOT(ISERROR(VLOOKUP(A1,Sheet3!A:B,2,0))),VLOOKU P(A1,Sheet3!A:B,2,0),
IF(NOT(ISERROR(VLOOKUP(A1,Sheet4!A:B,2,0))),VLOOKU P(A1,Sheet4!A:B,2,0),
"missing from all 3")))

(I stopped after looking at 3 sheets. You could continue until you try to add
the 8th lookup--excel can nest 7 functions.)

Rishab shah wrote:

I have data in my 5 sheets in the same work book.

Can vlookup command find the data from the 5 sheets.

--

Dave Peterson