many to one

  • Thread starter Thread starter Rich
  • Start date Start date
R

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".
 
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.
 
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.
 
Back
Top