matching from an unsorted list

D

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
 
F

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
 
Top