Works perfectly, Dave! Thank you so much! You have saved me hours of work and
probably baldness as well...from pulling out my hair!

Tea

"Dave" wrote:

Hi,
Try this modified, (though still lengthy) formula in E2 and copy down.
This assumes that <1 Gal, 5 Gal, 1 Qt are the only 3 possibilities.

=IF(ISNUMBER(FIND("5 Gal",A2)),D2/5,IF(ISNUMBER(FIND("1
Gal",A2)),D2,IF(ISNUMBER(FIND("1 Qt",A2)),D2*4,"Unknown Qty")))

Note that this page places unwanted spaces at the wrap points, which have to
be removed after pasting into XL.

If this doesn't do what you want, please tell me what it does wrong.

Regards - Dave.