|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
table
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
|