VLOOKUP & TWO DIFFERENT RANGES
Another one:
=VLOOKUP(A1,IF(COUNTIF(B1:B5,A1),B1:C5,Sheet2!B1:C 5),2,0)
--
Biff
Microsoft Excel MVP
"SSJ" wrote in message
...
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
|