Hello, I hope all are well. I have little query if someone can solve it.
I want the description tab of the purchase order to be populated if someone enters the order quantity into the master tab. I was using IF formula (I.e. IF(Master!K20>=1,Master!A20,"")&IF(Master!K21>=1,Master!A21,"")&IF(Master!K22>=1, Master!A22,"")&IF(Master!K23>=1,Master!A23,"") but it is adding more than one description line when customer enter order quantity against more than one item in the master tab. I want the formula to select only one description in a single row and another order in the second row.
Currently, when buyer putting order quantity for more than items into the master tab. The descriptions are adding with each other in a single line like this (Botanical Disinfectant Solution 55 galBotanical Odor Neutralizer 4/1 gal - Enzyme) - These are two items, not one. Please enter the quantity into the master tab of the attached file and see the result in the agreement tab.
Please help. Thanks
Bookmarks