How to determine a value from an associated range?

[Badmojoman1977]

Hi all,

I've seen a few flavors of this question asked, but not quite what I'm looking to do (maybe I missed it somewhere).

I have a table that contains a column with low value, a column that contains high values, and a column with an associated text field. Here's an example:

Low High Name
0 10000 John
10001 20000 David
20001 30000 Mike
30001 40000 Steve
...
100001 200000 Frank



On a separate sheet, I have a column of values. What I'm looking to do is, for each value, determine which range it falls in and pull in the associated name.

For example:

Value Associated Name
20983 Mike
932 John
39281 Steve

How can I create a formula or VBA module to pull in the associated names?

Thanks in advance!

 

[Peter_SSs]

Thanks Peter
I did pick that up, that's why I recommended Biffs approach in preference to mine.

Sorry Michael, I had misread your post slightly. I thought you had implied that both formulas could be used equally well. I have read it more carefully now.