Can't quite figure how to use INDEX/MATCH with Table using brackets (< and >)

[KomicJ]

I'm working on this project, where I have to apply a grade depending on value obtained.

Trick is, the system is bracket based, and those brackets are subject to change over time, so I don't want to include them in the formula itself. So I thought I would create a bunch of three columns tables with MIN, MAX and GRADE, so that we can easily change the brackets if necessary. However, I'm not quite sure how to use that table now.

I'm trying to find a way for the formula to look at the result on the MAIN tab, and find the appropriate bracket from the table, and return the appropriate value attached to that bracket.

I made a quick exemple, which is attached to this post.

If anyone has an input on the matter, it would be highly appreciated.

Thanks.

[ben_hensel]

On sheet Main in cell D3:

Please Login or Register  to view this content.

And pull down.

[AlKey]

Or this

Please Login or Register  to view this content.

[Pete_UK]

Put this in D3 of the Main sheet:

=VLOOKUP(C3,Table2,3)

then copy down.

Hope this helps.

Pete

[KomicJ]

Can't believe I couldn't figure that out myself. This is what happens when you only use INDEX/MATCH with Match type 0.

Thanks a lot guys, you're all awesome !

[Pete_UK]

Glad to help, and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete