many to one
 

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

many to one
 

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.

--
Regards,
Tom Ogilvy

"Rich" wrote in message
...
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".

many to one
 

how do a do a Match, vlookup, lookup, hlookup on a cell if
it is a range
-----Original Message-----
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.

--
Regards,
Tom Ogilvy

"Rich" wrote in message
...
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".


.

many to one
 

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.

--
Regards,
Tom Ogilvy

"Rich" wrote in message
...
how do a do a Match, vlookup, lookup, hlookup on a cell if
it is a range
-----Original Message-----
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.

--
Regards,
Tom Ogilvy

"Rich" wrote in message
...
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".


.