caritx
New Member
- Joined
- Dec 1, 2009
- Messages
- 34
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)))
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)))