Thread: MATCH function?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mwam423 mwam423 is offline
external usenet poster
 
Posts: 103
Default MATCH function?

greetings, i have fairly simple problem that i can't figure out. have single
cell which has text, and a column of zero, one, or up to twenty text entries
which i want to compare to the single cell and tell me if there's a match.
however, in the column, would like to be able to make entry with a wildcard,
e.g., Yes *, or Yes ??% so that if the single cell had Yes 10% or Yes 15%
would return a match. any help greatly appreciated!