matching from an unsorted list

[d fallon]

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

 

[Fred Smith]

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