table

  • Thread starter Thread starter ellebelle
  • Start date Start date
E

ellebelle

i have a table in excell:

3D J 1
3D LM 2
COMP L J 1
COMP LJ 2
COMP LM 3

I have a list of people with groups and ranks and would like to assign them
the appropriate number based on the table:

Jenny 3D J 1
George COMP LJ 1

Is there a way to do this without using an IF statement? My table is very
big and an IF would be enormous.

any help appreciated!

Ellen
 
Hi

From where would Excel find the linkage of Jenny to 3D J 1 or
George to COMP LJ 1?

Is there another table which will provide this info?

--
If this posting is helpful, appreciate that you click on the Yes button below

Thank You

cheers, francis
 
I would like to link Jenny 3D J to the number 1. Becasue the number 1 is
linked to 3D J in the top table. Does that make sense?
 
sorry, I don't understand this. Would you place your sample file at a free
filr hosting and let me the link or you can send it to me
--
Your feedback is very much appreciate, pls click on the Yes button below if
this posting is helpful.

Thank You

cheers, francis
 
ellebelle said:
i have a table in excell:

3D J 1
3D LM 2
COMP L J 1
COMP LJ 2
COMP LM 3

I have a list of people with groups and ranks and would like to assign them
the appropriate number based on the table:

Jenny 3D J 1
George COMP LJ 1

Is there a way to do this without using an IF statement? My table is very
big and an IF would be enormous.

any help appreciated!

Ellen
Click to expand...


See if this helps:

http://www.contextures.com/xlFunctions03.html#IndexMatch4
 
Back
Top