Here you go:
=VLOOKUP(Left(A1,FIND(",",A1)-1),$0$2:$P$13,2,0)
The $ signs lock in the range.

(I got sloppy on that one...sorry)

--
Regards,
Ron


"lrb" wrote:

Ron,

Yes it does! Thank you. One last question. Is there a way to copy this
formula and paste to MANY cells below it? When I try to copy and paste it
doesn't pick all the cells in the array table.

Thanks again for your help! I definately couldn't have figured this out on
my own!

"Ron Coderre" wrote:

IF Cel A1 contains EE+Fam-A, FlexMed ($41.66)
AND Col O has data like EE+Fam-A
AND Col P has amounts
THEN this formula should return the amount associated with EE+Fam-A:
=VLOOKUP(Left(A1,FIND(",",A1)-1),02:P13,2,0)

Does it?
--
Regards,
Ron