Most people would use the Vlookup function. Read up on it in Help. Pay
special attention to the last parameter. Post back if you need help.

Regards,
Fred

"d fallon" <d wrote in message
...
I'd like to match (exact) names from a range of text, but the range is
unsorted.
Is there a function or method to do this?

i.e. I enter a name in a cell, and a formula would take that cell and
match
against a range of names.
thanks