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