Previous Topic Next Topic

Look for a value into different ranges

Solved/Closed
Kato - 3 Jun 2010 à 12:31
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 4 Jun 2010 à 08:34
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)

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
3 Jun 2010 à 13:46
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
Kato
3 Jun 2010 à 14:30
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 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
3 Jun 2010 à 15:18
try this formula


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

This assumes that values in column A is sorted.
Kato
4 Jun 2010 à 07:50
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 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
4 Jun 2010 à 08:34
I know exactly what you mean, Been there, done that too,

You are very welcome.

Similar discussions

Excel Macro - Set and autofill a range?
KT -
excel987 -

28 responses
Copy and paste one cell into 48 and then repeat
katie456 -
TrowaD -

1 response
range of numbers
whatsit -
Mazzaropi -

3 responses
How to use name range..Please help to solve this issue..
mathewmunna -
Mathewmunna -

4 responses
Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses