Need help with if formula

New Contributor


I need some help with a if formula,  if column E value falls with the Wight basic rates in column a & b to equal the cost in column c.


Example: if I enter in 10 in E2 , I need the cost of $23 to fill in Column F2, then if I enter in 50 the cost of $25 will fill in F3. 



3 Replies


In F2:

=VLOOKUP(E2, $A$2:$B$8, 2)

Fill down.

will it work if I end in a number in between like 27?


Yes. If you don't specify FALSE as 4th argument of VLOOKUP, the formula will return the value in the second column corresponding to the last value in the first column that is less than or equal to the lookup formula. Just try it!