I'm trying to use the VLOOKUP and need to know if it is possible to look up
text that "contains" the values in my table array, but is not an exact match.


For example ... my table array says "EE-A", but the cell I'm comparing it to
contains "EE-A, FlexMed ($25.00)". Is there a way to write the formula so
that it will recongnize the information before the comma (or some other type
of break) and will return the value assigned to the "EE-A" in my table array?
I don't know what it would be called or how to write it. It should be a
type of formula that if the cell "contains" but is not exactly equal to ...
any suggesetions?