Lookup formula: bring back the closest number and convert it into a letter

Hi all,

I am having a mind blank today. I want to use a formula that will bring back the closest number and convert it into a letter (normally use vlookup or lookup but it doesn't seem to want to work for me today)

I have attached an example of what I need. The data is one tab and the data I want it to look up is on the 2nd Tab

For example, if Column/Row D2 has a mark of between 7 and 13 it will bring a number "1" into column/row E2 etc

Sorry if I am rambling. I'm not very good at explaining.

Thank you in advance

Clare

Hi,

Reverse the order of your boundary table so that rows B3:B7 are in ascending order then use

=VLOOKUP(D2,boundry!$B$3:$C$8,2)

Incidentally your data validation is set to a maximum of 40 so you could never get a 5 as it stands

Administrative Note:

Welcome to the forum.

Your thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As yo are new, I have changed the title for you this time.)