Help with IF AND/IF OR and a VLOOKUP

[thewiseguy]

Hi all. I've looked all over for a similar problem and solution but could not find one. Any help is greatly appreciated!

Trying to create a formula that says:

IF (A1="TEST" AND B1 IS BETWEEN 20-149, THEN 10. IF (A1="TEST" AND B1 IS >149, THEN 50. OTHERWISE, VLOOKUP (A1, TBL_GOOD),5,0)

thanks in advance!!!

 

[Joe4]

It should simply be a matter of nesting IF statements and adding in your VLOOKUP (assuming that is a valid VLOOKUP formula), i.e.

=IF(AND(A1="TEST",B1>=20,B1<=149),10,IF(AND(A1="TEST",B1>149),50,VLOOKUP(A1,TBL_GOOD,5,0)))

 

[thewiseguy]

It should simply be a matter of nesting IF statements and adding in your VLOOKUP (assuming that is a valid VLOOKUP formula), i.e.

=IF(AND(A1="TEST",B1>=20,B1<=149),10,IF(AND(A1="TEST",B1>149),50,VLOOKUP(A1,TBL_GOOD,5,0)))

Thank you Joe, that worked perfectly.

 

[Joe4]

You are welcome.
Glad I was able to help!