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









"ellebelle" wrote:

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

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" wrote:

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" wrote:

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

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" wrote:

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" wrote:

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" wrote:

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

ellebelle wrote:
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/xlFunctio...ml#IndexMatch4

Thank you so much! That has done it.

"Glenn" wrote:

ellebelle wrote:
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/xlFunctio...ml#IndexMatch4