Excel-Display corresponding value from table based on number in list

[milcman]

I have a list of client names in one column and a random number between 1 & 200 associated with each name. I also have a table of numbers, 1 through 200 with a letter designation for each number, (a,b,c,...aa,ab,...ga). I am trying to figure out how to use a formula to assign a letter(s) to a name based on the corresponding number by each name.

Any suggestions?

Clint

Clint Galliano
Halliburton Energy Services
BAROID PSL
"Done ONCE, Done RIGHT!"

 

[DirkStruan]

Have a look at the Match & Index function.

If your table is like:

1 2 3 4 etc
Z T E N etc

lets call the second row of the table letter_row

and your data is

name1 4
name2 1
etc

in cell C2 you can simply have =index(letter_row,B2).

The letter returned everytime the random number changes.

However, if the table is more like (which I doubt)

5 1 4 8 etc
W P G T etc

Then you will need to use the Match function based on B2 and the top row of the table to find the correct entry and then use this in the Index function working on the bottom row.


Dirk

Everything useful perishes through use....Should I not rejoice at being useless?