Ron you rock! I don't know how you know all this stuff, but you're awesome!
This is going to save me huge amounts of time PLUS it will make sure my
dollars are correct rather than relying on my brain and fingers to enter the
right info!

Thanks so much!

"Ron Coderre" wrote:

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