table

[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

 

[xlmate]

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

 

[ellebelle]

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?

 

[xlmate]

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

 

[Glenn]

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

See if this helps:

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

 

[ellebelle]

Thank you so much! That has done it.

See if this helps:

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