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

  • Thread starter Thread starter Jim Bringhurst
  • Start date Start date
J

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
 
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
 
Back
Top