Using if statements and vlookups

[bj6264]

Hellom I'm trying to write a formula that says if a3=ap then lookup a certain range but if a3=br then lookup another range, can another help?
bj6264

 

[Gerald Higgins]

I think you're almost there.
You want something like this.

=if(a3="ap",[insert first lookup formula here],
if(a3="br",[insert second lookup formula here],
[specify what you want to do if a3 is neither "ap" nor "br"]))

 

[bj6264]

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

 

[Gerald Higgins]

Well one possibility is that it's not finding the B3 value in the relevant lookup range.

I'm not sure what you mean by this -
"ap or br is a vlookup of b3 so will then use b3 for my lookup"

 

[bj6264]

Hi

thanks, all sorted