Unit increase relative to variable unit thresholds

Hello,

I'm trying to structure thresholds with relation to an increasing unit amount. Please see attached image.

I have my increasing "value", and a connected "earn" and "level". The level is only achieved if it is the same amount or higher than the "value" amount.

I have added a "manual edited level" as the target.

Sorry for the cack handed explanation...does any one know what formula I would need to fill the red cells with the "earn" and "level" being known?

Thanks for any help.
Untitled2.png

Hi,

Thanks for the reply, but this doesn't get the answer I'm looking for.

The vlookup just bring back exact or approximate matches, which are no good.

Here is a slightly better image of what I need: 123.png
The green is the value I'm looking for. That number is the Level (F) once the Value (A) is the same or greater than the Earn (E).

I hope that's clearer.

Again thanks for any help.

Sorry brain not functioning at today.

There is a typo in the above image, row D6 should have been a 7. Here it is again: 456.png

I've been trying to us this formula:
=IF(A2<=0,1,IF(A2<=9,2,IF(A2<=34,3,IF(A2<=74,4,IF(A2<=136,5,IF(A2<=226,6,IF(A2<=349,7,IF(A2<=516,8,IF(A2<=727,9)))))))))

But it beings back what you see in column B, which is 1 level off the desired amount for some reason.

Right problem solved. This is the formula I needed:

IF(A2>=727,9,IF(A2>=516,8,IF(A2>=349,7,IF(A2>=226,6,IF(A2>=136,5,IF(A2>=74,4,IF(A2>=34,3,IF(A2>=9,2,IF(A2>=0,1)

Originally Posted by ChemistB

Sixth Sense's Formula works and is much simplier than the one you are trying to use. What was your issue with VLOOKUP? See attached where I used his formula in your worksheet.

Sorry only just seen your post. Urg, can't believe I missed that. I didn't think the Exact (TRUE) match worked like that. Thanks for the help.