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