Auto Populate with Data Validation

[bronkista]

Hi,

Can you please help me on a formula that would auto populate cells based on a choice from a list using data validation?

TIA!

[Bob Phillips]

Don't understand, what do you expect to get?

[gshocker08]

What you would need to do is--do a vlookup with the lookup value as the cell with data validation.

[bronkista]

Sorry 'bout that Bob,

I'm attaching an edited file...

What I'm hoping to happen is that, the cells highlighted in yellow will auto populate
upon choosing a "Mode of Payment" from data validation list.

Thanks.

[bronkista]

gshocker08,

I think you mean HLOOKUP, but that would only return 1 item from the list.

thanks.

[Bob Phillips]

Use

=IF(INDEX(List!B:D,ROW($A3),MATCH(Selection!B$3,List!$1:$1,0)-1)=0,"",INDEX(List!B:D,ROW($A3),MATCH(Selection!B$3,List!$1:$1,0)-1))