Auto-fill when selecting from dropdown

[Sandy737]

Hi all. I’m new here, so a huge thanks to anyone that can help me with this.

Help with “dynamic/auto-fill when selecting from dropdown”.

I know how to create a drop-down list.

What I need is, when I make a selection from that drop down, the columns to the right auto fills/populates with the same data that’s in the source table corresponding row.

Example attached.

Thanks again.

 

[Fluff]

How about using a Vlookup formula?

 

[Sandy737]

How about using a Vlookup formula?

Hi Fluff. Thanks for the reply. I have tried but I don't know how to do it.
It's a shame I can't upload the file for people to see.

 

[Fluff]

You can use the XL2BB add-in to post some sample data

 

[Sandy737]

I've tried following the instructions but it doesnt appear in the list of add ins after downloading

 

[Fluff]

Did you un-zip the file & copy the add-in to your add-ins folder?

 

[Sandy737]

Still not showing

 

[Fluff]

if you go to Options & add-ins, does it appear anywhere in the list

And is the path highlighted, where you copied the xlam file to?

 

[Sandy737]

Nothing like that

 

[Fluff]

Is the path that I highlighted the same place you put the xlam file?