# Look for a value into different ranges

Solved/Closed
Kato - Jun 3, 2010 at 12:31 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jun 4, 2010 at 08:34 AM
Hello,

PLeas take a look on the following data
A B C D E
Range 1 Range 2 NAME
810000 810190 Aurora 81000 formula or Macro that can give me the name
820200 820200 Casper 810170 formula or Macro that can give me the name
820240 820295 Nut 820275 formula or Macro that can give me the name
830300 830300 Welldone etc, etc
830310 830360 Nikita
830380 830395 Mary

I am trying to look for a formula or macro that I can place on the cells of column E that look the value from column D into the different ranges of A and B for each row and then give the name of the range (column C)

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 3, 2010 at 01:46 PM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
Here is the file
https://authentification.site/files/22778032/Value_vs_Ranges.xls
I placed a brief explanation of what I am looking for, I hope it will be understandable
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 3, 2010 at 03:18 PM
try this formula

=VLOOKUP(D2, A:C, 3, true)

This assumes that values in column A is sorted.
Thanks a lot, I was visualizing a complicated solution, some times I forget to visualize the simple things. I really appreciate your help, you saved me a lot of time. Best regards
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 4, 2010 at 08:34 AM
I know exactly what you mean, Been there, done that too,

You are very welcome.