I am trying to lookup a value in a table using 2 conditions:
a b c
fred 20 20 20
mary 5 1 1
jane 5 5 8
stan 11 12 10
Based on the the "name" column I need to retrieve the appropriate rate for that customer based on a transaction type A, B, or C. Previously before MARY I could use the formula below. Now with MARY I need to upgrade this. For some reason, maybe its the parathensis, I cannot edit the formula. This is what I used previously:
=IF(OR(F2="B",F2="A"),VLOOKUP(D2,$T$2:$V$14,2,FALSE),VLOOKUP(D2,$T$2:$V$14,3,FALSE))
Any help is greatly appreciated!
a b c
fred 20 20 20
mary 5 1 1
jane 5 5 8
stan 11 12 10
Based on the the "name" column I need to retrieve the appropriate rate for that customer based on a transaction type A, B, or C. Previously before MARY I could use the formula below. Now with MARY I need to upgrade this. For some reason, maybe its the parathensis, I cannot edit the formula. This is what I used previously:
=IF(OR(F2="B",F2="A"),VLOOKUP(D2,$T$2:$V$14,2,FALSE),VLOOKUP(D2,$T$2:$V$14,3,FALSE))
Any help is greatly appreciated!
