Excel multiple IF conditions

Closed
RPJ - Nov 11, 2015 at 11:10 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 11, 2015 at 02:47 PM
Hi

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'
etc.......

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

Thanks!
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 11, 2015 at 02:47 PM
well it would depends on how you are populating the description in the list box.
one way to do would be to use IF statement, or vlookup or use vba
0