Hi Al,

Take a look at VLOOKUP using all 4 arguments.

HTH
Regards,
Howard

"Al" wrote in message
...
I am trying to match a list of names to return a number.
I have tried an IF but I can't nest more than 7
I have tried lookup but it is not anexact match
Match is no good as it gives a relative position
What is the right function/formula for this?
Thanks