Help with nested if statements with vlookups

[tiltz]

I am trying to have a multiple criteria if statement to vlookup a value based region (which each is on a different tab). Each of the if statements work fine on their own, but not combined. What am i doing wrong here:

=OR(IF(A2="USA",VLOOKUP(B:B,USA!A:B,2,FALSE),"NA"),IF(A2="CAN",VLOOKUP(Canada!A:B,2,FALSE),"NA"),IF(Tracker!A2="EMEA",VLOOKUP(EMEA!A:B,2,FALSE),"NA"),IF(Tracker!A2="LATAM",VLOOKUP(LATAM!A:B,2,FALSE),"NA"),IF(Tracker!A2="Non-integrated",VLOOKUP(Non-Integrated!A:B,2,FALSE),"NA"))

 

[tiltz]

I see now. Thanks for the help! The "=IFERROR(VLOOKUP(Tracker!$B2,INDIRECT(Tracker!$A2&"!$A:$B"),2,FALSE),"NA")" formula is much more elegant. Much prettier than the nested if statement.

 

[wideboydixon]

Or this which might fix my original solution:

=IFERROR(VLOOKUP(Tracker!$B2,INDIRECT("'"&Tracker!$A2&"'!$A:$B"),2,FALSE),"NA")

WBD