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!
|