|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:|
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.
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.