many to one

[Rich]

i have a table that has names and in each cell a range e.g.

Sovereign =100 =100 =99000 =99000
Energy >=1000 <=1200 >=2300 <=2300
Utilities >=4000 <=4100 >=6400 <=6600


I have another table that has data and column G relates
to the ranges in the first table. If the number was for
example was "1100" how can i get to the
answer "Energy".

 

[Tom Ogilvy]

You would be better off reorganizing your table to support one of the lookup
function rules such as Match, vlookup, lookup, hlookup. See the help on
these functions for how they operate.

 

[Rich]

how do a do a Match, vlookup, lookup, hlookup on a cell if
it is a range

 

[Tom Ogilvy]

Like I said, you have to organize your data to support what the functions
will do. How they operate is spelled out in great detail in help - a lot
better than I could explain it here.