Nov 11, 2015 at 11:10 AM
Posts4478Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Nov 11, 2015 at 02:47 PM
I have 9 different descriptions of trailer loads in Column D (they are programmed so I can choose them from a drop down list). Then in Column F I want it to automatically input the correct code for the trailer load.
I.e. If column D says 'Potatoes' Column F should say '02 02 02'
If column D says 'Whey' Column F should say '02 02 04'
Each trailer load will only ever relate to one code, but each code could have several load types.
I.e. Potatoes would be 02 02 02, but also Daf could be 02 02 02