LOOKUP against 2 named ranges

[RaunLGoode]

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))
and
=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.

 

[June7]

Asking an Excel question in an Access forum?

Why does it need to be all in one cell? Do the calcs in individual cells then in a third cell do an If() to select result. The first 2 columns can be hidden.

 

[NBVC]

Try:

=IFNA(VLOOKUP(E2,Range-A,5,FALSE),IFNA(VLOOKUP(E2,Range-B,3,FALSE),""))

 

[Kiwiman]

=iferror(vlookup(E2,range-a,5,0),iferror(vlookup(E2,range-b,3,0),""))

Sent from my SM-G900F using Tapatalk