Can I combine an "if" statement in a vlookup formula?

[Jim Bringhurst]

I am trying to write a formula where the vlookup will find
a cell and then use a if function to see if it is larger
than a certain number then use a multiplier. Is this even
possible?

Thanks
Jim

 

[L. Howard Kittle]

Hi Jim,

I think so, if I understand your question.

=IF(VLOOKUP(D1,A1:B5,2,0)>C1,"Multiplier","Not greater")

Where the number is in D1 and is compared to a number in C1. "Multiplier" &
"Not greater" can be either values or cell references.

HTH
Regards,
Howard