Ron,

I tried this but still get an error. My actual information doesn't have ""
around it. I don't know if that has something to do with the problem.?
Here's what the cell looks like: EE+Fam-A, FlexMed ($41.66) and here is what
I need it to find from the table array: EE+Fam-A $739.46

I need it to see that the EE+Fam-A, FlexMed ($41.66) corresponds to the
result of $739.46 even though there is a ,FlexMed ($41.66).

To say the least, I am a NOVICE at writing/using these type of functions.
I'd appreciate your advice.
Lisa



"Ron Coderre" wrote:

Try this:
=VLOOKUP(Left(A1,FIND(",",A1)-1),YourTableOfData,YourValueToReturnCol,0)
That will take the EE-A from "EE-A, FlexMed ($25.00)" and find that value in
your table.

Does that help?
--
Regards,
Ron


"lrb" wrote:

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?