Do your 7 sheet names follow some sort of sequential pattern like Week1,
Week2, Week3?

--
Biff
Microsoft Excel MVP


"keithobro" wrote in message
...
I want to get a master worksheet to check for a candidate's details across
7
other worksheets. If the VLOOKUP fails to find that person on sheet 1, it
tries sheet 2, then sheet 3 and so on.

can this be done? is it a question of replacing the FALSE part with the
next
VLOOKUP formula?

Thanks.

Keith