Vlookup

[RJB78]

I'm looking to use a vlookup in 'tab1' to find a value in 'tab2', if it cant find it in 'tab2', then look for it in 'tab3', if it cant find it in either, "N/A"

In tab1, I have a name in cell A1. In column C I want to use the vlookup to lookup the name from A1 from a list containing the names in Tab2, if it doesn't find a value in tab2, I would like to look for the vale in tab3


Thank you in advance

 

[RJB78]

Why not both? It seemed to accomplish the desired result. Am I missing something?

Here is formula I have now:
=IFERROR(IFNA(VLOOKUP(A5,'Cur. Pos.'!A:J,10,FALSE),VLOOKUP(A5,'Other Data'!A:C,3,FALSE)),"NA")

 

[Aladin Akyurek]

Why not both? It seemed to accomplish the desired result. Am I missing something?

Here is formula I have now:
=IFERROR(IFNA(VLOOKUP(A5,'Cur. Pos.'!A:J,10,FALSE),VLOOKUP(A5,'Other Data'!A:C,3,FALSE)),"NA")

I'd have one of:

=IFNA(VLOOKUP(A15,'Cur. Pos.'!A:J,10,0),VLOOKUP(A5,'Other Data'!A:C,3,0))
=IFNA(VLOOKUP(A15,'Cur. Pos.'!A:J,10,0),IFNA(VLOOKUP(A5,'Other Data'!A:C,3,0),"NA"))
=IFERROR(VLOOKUP(A15,'Cur. Pos.'!A:J,10,0),VLOOKUP(A5,'Other Data'!A:C,3,0))
=IFERROR(VLOOKUP(A15,'Cur. Pos.'!A:J,10,0),IFERROR(VLOOKUP(A5,'Other Data'!A:C,3,0),"NA"))

By the way, 0 means also FALSE in Excel.