LOOKUP against 2 named ranges
I am using VLOOKUP to find a value in a named range(Range-A). I am using IFNA to trap values the Return "N/A" when no match is found. I then create a VLOOKUP to look in a different table (Range-B) for a match.
=IF(ISNA(VLOOKUP(E2,Range-A,5,FALSE)), "", VLOOKUP(E2,Range-A,5,FALSE))
=IF(ISNA(VLOOKUP(E2,Range-B,3,FALSE)), "", VLOOKUP(E2,Range-B,3,FALSE))
I would like to combine these 2 steps into a single process to Search Range-A for a value, and if not found, Search Range-B for the value. Ideally If the value isn't found in either range, I'd like to use IFNA to trap that condition.
I have looked in this and other forums and haven't found a solution. I'd really appreciate some help, if anyone has done this before.