Vlookup from a range of values

[samyraj]

Hi
I have a table (Table no 01) with a low and high value and a name for this range.
I have the second table (table 02) with a value and I want to populate the name of the range from Table 1 if the value falls within a given range
Is there a way use a formula to perform this Vlookup
Sample file attached.
Thank you in advance

[AliGW]

Are you still using Excel 2019?

In C3:

=VLOOKUP([@Reference],$F$2:$H$10,3,1)

[samyraj]

Hi
Sorry the formula did not work in C4, as the VLookup has to look the range of the values between two coloumns. I am using Excel 2021

[AliGW]

Did you try it?

Have a look at the attached. It produces what you wanted, I believe.

Please update your forum profile.

[samyraj]

Thank you, sorry it was my bad

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.