"Read" wrote:
This formula copied down column B makes an entire column of bread. It never
recognizes the change to milk? I'm still confused?

How about a quick working sample to take-away & unravel it all?
Should help give clarity:
http://freefilehosting.net/download/42m1h
Read.xls

(Sample also contains TM's neater, single formula solution)

There you go. Do remember to press the YES buttons (like the one below) in
ALL responses which helped you in this thread, won't you?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---