VLOOKUP & TWO DIFFERENT RANGES
Mike,
It worked perfectly!
Thank you
SSJ
"Mike H" wrote in message
...
one way
=IF(ISNA(VLOOKUP(D1,Sheet1!A1:B11,2,FALSE)),VLOOKU P(D1,Sheet2!A1:B11,2,FALSE),VLOOKUP(D1,Sheet1!A1:B 11,2,FALSE))
Mike
"SSJ" wrote:
Hello All,
Can VLOOKUP lookup in two different different ranges residing in separate
worksheettabs? In other words, if a match is not found in the first range
then lookup the 2nd range.
Can someone help in constructing such formula?
Regards
SJ
|