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

A B C

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

A B

1 7Low

2 38High

3 15Med

Where A is the value used to look up and B is returned from Sheet 1I am not sure if Lookup or Indexing will work, I am thinking it will need some VBA, but not sure.

Sincerely,

albay

Post this in the Office Software forum here: http://www.computing.net/forum/offi...

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

Ask Your Question

Weekly Poll

Do you think Google Fiber has a strong future?

Discuss in The Lounge

Poll History