View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
d fallon d fallon is offline
external usenet poster
 
Posts: 1
Default matching from an unsorted list

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