Excel 2007 : Multiple cells filled in based on dropdown list

[brettc23]

Hello,

My brain is hurting!

I'm looking for a way to automatically populate information in cells based on a drop down selection using data validation.

Example:

If i choose 3 from the list on column F, it should automatically populate 'used' in column E and 'truck' in column G on the same row.

Thanks for any advice

[JBeaucaire]

In E1, this formula:

=IF($F1="", "", INDEX($E$20:$E$26, $F1))



In G1:

=IF($F1="", "", INDEX($G$20:$G$26, $F1))