Hi, get an n/a answer. this is my formula
=IF(I1="ap",VLOOKUP(B3,Sheet1!$A$1:$C$14,3),IF(I1="br",VLOOKUP(B3,Sheet1!$D$1:$G$14,3),"0"))
the ap or br is a vlookup of b3 so will then use b3 for my lookup. Can you see anything obvious that I'm doing wrong?
bj6264