Excel multiple IF conditions

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
769
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