vlookup twice in one formula

[caritx]

i have a file and in in column A I have data. I need to do a vlookup in "Tab1" to and if there is a value to return it. If the value is not there then check "Tab2" and bring back the value.

Now the problem is that the value might be in both but I always want the "tab1" value before it goes to "tab2".

Can someone help?

I tried this but it would go to "tab2" and ignore "tab1"

=LOOKUP(REPT("z",255),CHOOSE({1,2,3,4}," ", VLOOKUP(AL2,tab1!$A$1:$B45870,2,0),VLOOKUP(AL2,tab2!A2:D1209,4,FALSE)))

 

[Jonmo1]

Try

=IF(ISNA(VLOOKUP(AL2,tab1!$A$1:$B45870,2,0)),VLOOKUP(AL2,tab2!A2:D1209,4,0),VLOOKUP(AL2,tab1!$A$1:$B45870,2,0))

 

[VoG]

Try

=if(isna(VLOOKUP(AL2,tab1!$A$1:$B45870,2,0)),VLOOKUP(AL2,tab2!$A$1:$B45870,2,0),VLOOKUP(AL2,tab1!$A$1:$B45870,2,0))

 

[caritx]

Thank you both! Awesome!