Each sheet represents a different interview location

I guess that means the answer to my question is no?

Why?

The information you provide will determine what kind of suggestions you'll
get.

Make a list of your sheet names and give this list a defined name:

B1:B7 = list of sheet names = defined name WSList

A1 = lookup value

Try this array formula** :

=VLOOKUP(A1,INDIRECT("'"&INDEX(WSList,MATCH(TRUE,C OUNTIF(INDIRECT("'"&WSList&"'!B1:B7"),A1)0,0))&"' !A:B"),2,0)

Assumes the table_array on each sheet is in the range A:B.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)



--
Biff
Microsoft Excel MVP


"keithobro" wrote in message
...
Each sheet represents a different interview location with up to 200 names
on
each. Why?

"T. Valko" wrote:

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