Look for a value into different ranges

Solved/Closed

Kato - Jun 3, 2010 at 12:31 PM
rizvisa1 Posts 4478 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)

Look for a value into different ranges
Excel formula if cell contains date range then return value ✓ - Office Software Forum
Relative worksheet reference in formula for chart data ranges? - Excel Forum
Copy row if a range of column matches a value ✓ - Office Software Forum
Want to increment a Alphanumeric value in a range of cells - Excel Forum
Conditional formatting for range of numbers ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Kato
Jun 3, 2010 at 02:30 PM

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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
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.

Kato
Jun 4, 2010 at 07:50 AM

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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 4, 2010 at 08:34 AM

I know exactly what you mean, Been there, done that too,

You are very welcome.

Similar discussions

Excel if range of cell contain a text put a cell value in

Excel Macro/Code help: Creating sheet for each name in column of another sheet

Applying my macro to a range of cells...

Copy range data in a column to new column.

Make a macro run when data entered in a cell

Similar discussions

Subscribe To Our Newsletter!