Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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". |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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". |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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". . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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". . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|