Forum Discussion

Copper Contributor

Feb 28, 2023

Need help with if formula

HI 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 $2...

excel

HansVogelaar

MVP

Feb 28, 2023

112233375

In F2:

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

Fill down.

112233375
Copper Contributor
Feb 28, 2023
will it work if I end in a number in between like 27?
- HansVogelaar
  MVP
  Mar 01, 2023
  112233375
  
  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!