if statement with Vlookup

[jgold20]

I have an if statement and I want to add an additional if(Vlookup) to it. The first if statement is handling a specific rule. I want the if(lookup) to handle everything else. The fields for the 1st if statement are blank in 'Company Info'. Can this be done as I am getting an error?

=IF(OR(A3={"D","SR","V","X"}),
IF(AND(C3>1,C3<400),50,IF(AND(C3>399,C3<500),75,IF(AND(C3>499,C3<1001),100,IF(AND(C3>1000),150,0)))))+
if(VLOOKUP($A$3,'Company Info'!A1:j24,10,FALSE)*A9

 

[jtakw]

Hi,

Not entirely sure what you mean.

Cleaned up your IF statement and incorporated the VLOOKUP:

=IF(OR(A3={"D","SR","V","X"}),IF(AND(C3>1,C3<400),50,IF(C3<500,75,IF(C3<1001,100,150))),IFERROR(VLOOKUP($A$3,'Company Info'!A1:J24,10,FALSE)*A9,0))

 

[jgold20]

Thank you

 

[jtakw]

You're welcome.