Excel Range Lookup

Lenovo / 19514tu
October 19, 2009 at 13:53:04
Specs: Microsoft Windows XP Professional, 1.828 GHz / 1014 MB
I am looking to find out if a specific value falls in a range of values on a separate sheet and return a value. For example:

Sheet 1
1 0 10 Low
2 11 30 Med
3 31 50 High
Where A is the lower value in a range, B is the upper value in a range and C is the value of anything falling in that range.

Sheet 2
1 7 Low
2 38 High
3 15 Med
Where A is the value used to look up and B is returned from Sheet 1

I am not sure if Lookup or Indexing will work, I am thinking it will need some VBA, but not sure.


See More: Excel Range Lookup

Report •

October 19, 2009 at 15:40:35
Post this in the Office Software forum here:


Home Page http://ewen.uuuq.com/

Report •
Related Solutions

Ask Question