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