if statement with vlookup - returning false

[jgold20]

I have 3 different conditions and I am trying to use vlookup. Only the 1st if(and statement works. The 2nd and 3rd if(and return FALSE from the vlookup (***note each if(and statement works by its self***). Can I use if(and vlookup with the statements below?. The 2nd set of code works

=IF(OR(A9=""),"",
IF(AND($D$3="yes"),IF(OR($A$3={"D","DT","V","X"}),(J9*5%+125)),
IF(AND($D$3="yes"),IF(OR($A$3={"GE","SR","VP"}),VLOOKUP($A$3,'Company Info'!$A$1:$L$25,8,FALSE)*D9),
IF(AND($D$3="yes"),IF(AND(D9<3333.34),VLOOKUP($A$3,'Company Info'!$A$1:$L$25,8,FALSE)*D9,200),0))))


WORKS
=IF(OR(A9=""),"",
IF(AND(D3="yes"),IF(OR(A3={"D","DT","V","X"}),(J9*5%+125),0))+
IF(AND(D3="yes"),IF(OR(A3={"GE","SR","VP"}),(D9*E6),0))+
IF(OR(A3={"B","H","L","M","MD","MN","N","NO","Q","R","W","WG","Y"}),
IF(AND(D3="yes"),IF(AND(A9<3333.34),(D9*E6),200))))

 

[jgold20]

I thought I did that in post #6 . If not, please let me know exactly what I need to post. Ty

 

[jgold20]

I have multiple tabs that use the same formula in different places on their sheets. I am trying to make maintaining them easier. I thought if I was able to do a vlookup it would help to accomplish this. Due to different calculations, I am forced to have some alpha characters in 2 of the If statements. For the last If statement, it should default to the remaining alpha and do a vlookup without any alpha characters. The following rules apply:

1. If A9=blank, do not do anything.
2. If C3=NO, return 0
3. If C3=Yes:
   1. and A3=D, DT, V, X - E9=J9*5%+125
   2. and A3=GE, SR, VP - E9=Vlookup col. 8*D9
   3. and A3=any other "alpha" and
      1. D9 <3333.34 - E9=Vlookup col. 8*d9
      2. If D9 >3333.33, E9=200

Hopefully this is a better explanation.
Ty

 

[jgold20]

The code below does work:

=IF(OR(A9=""),"",
IF(AND(D3="yes"),IF(OR(A3={"D","DT","V","X"}),(J9*5%+125),0))+
IF(AND(D3="yes"),IF(OR(A3={"GE","SR","VP"}),(D9*E6),0))+
IF(OR(A3={"B","H","L","M","MD","MN","N","NO","Q","R","W","WG","Y"}),
IF(AND(D3="yes"),IF(AND(A9<3333.34),(D9*E6),200))))

 

[jgold20]

UPDATE - I have the formula working except for Step 3.2 from post # 22. Based on what I am trying to do, with this step, I think I have to go back to my original formula. The reason for this is that I do not want 200 to be a value for anything but all other ALPHA characters that are not in the first 2 IF(AND statements:

=IF((A9=""),"",
IF(AND(D3="yes"),IF(OR(A3={"D","DT","V","X"}),(J9*5%+125),
IF(AND(D3="yes"),IF(OR(A3={"GE","SR","VP"}),IFERROR(VLOOKUP($A$3,'Company Info'!$A$1:$J$25,8,FALSE)*D9,0),
IF(AND(D3="yes"),IF(AND(A9<3333.34),IFERROR(VLOOKUP($A$3,'Company Info'!$A$1:$J$25,8,FALSE)*D9,0),0)))))))

 

[RoryA]

Your formula cell references don't match the ones in your description.

Best guess:

=IF(A9="","",IF(D3<>"Yes",0,IF(OR(A3={"D","DT","V","X"}),J9*5%+125,IF(OR(A3={"GE","SR","VP"}),IFERROR(VLOOKUP($A$3,'Company Info'!$A$1:$J$25,8,FALSE)*D9,0),IF(A9<3333.34,IFERROR(VLOOKUP($A$3,'Company Info'!$A$1:$J$25,8,FALSE)*D9,0),200)))))

 

[jgold20]

Excellent Guess. It works perfectly.

Thank you very much

 

[RoryA]

Glad to help.