Can I VLOOKUP in 7 different worksheets in 1 formula?
Which version of Excel are you using? If Excel 2003 or prior, you are
limited to 7 levels of nesting, in Excel 2007, you have 64 levels of
nesting.
Tyro
"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
|