Forum Discussion
I need this value to fit these ranges $ 39.03 = Min. Good Better Best $ 32.11 $ 35.68 $ 36.70 $ 39.52
hi Joe,
i want $39.03 to equal "Min, good, better or best criteria." For example, $39.03 falls under better criteria.
Min Good Better Best
$ 32.11 $ 35.68 $ 36.70 $ 39.52
i want $39.03 to equal "Min, good, better or best criteria." For example, $39.03 falls under better criteria.
Min Good Better Best
$ 32.11 $ 35.68 $ 36.70 $ 39.52
ashika565 wrote: ``For example, $39.03 falls under better criteria.``
Much better explanation! But you might be omitting some other details.
Ostensibly:
=LOOKUP(A1, {32.11, 35.68, 36.70, 39.52}, {"Min", "Good", "Better", "Best"})
where the value in A1 might be 39.03.
Better:
1. Enter 32.11, 35.68, 36.70 and 39.52 into X1:X4
2. Enter Min, Good, Better and Best into Y1:Y4
Then the formula is:
=VLOOKUP(A1, $X$1:$Y$4, 2)
But what if A1 is less than 32.11?
If that might an issue, write:
=IFERROR(VLOOKUP(A1, $X$1:$Y$4, 2), "Error")