Can I VLOOKUP in 7 different worksheets in 1 formula?
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
|