Auto-fill when selecting from dropdown

Sandy737

New Member
Joined
Apr 21, 2020
Messages
45
Office Version
  1. 2016
Platform
  1. Windows
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.
 
Mine is in;
C:\Program Files\Microsoft Office\root\Office16\ADDINS
 
Upvote 0

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Mine is in;
C:\Program Files\Microsoft Office\root\Office16\ADDINS
 
Upvote 0
Do you have a folder like
C:\Users\Username\AppData\Roaming\Microsoft\AddIns
If so that is where you need to put the add-in
 
Upvote 0
That got it!! Now I have to work out how to copy the SS to this post
 
Upvote 0
I think I may have got it to work, but I can’t get the cells to show nothing when the lookup value cell is empty.

=VLOOKUP($P6,$B$4:$J$300,2,FALSE)) This works but when value cell is empty it returns “N/A”

=IF(SUM(P6)=0,"",VLOOKUP($P6,$B$4:$J$300,2,FALSE)) This stops the VLOOKUP working altogether.

How do i upload a copy of the SS pls?
 
Upvote 0
Try
=IF(P6="","",VLOOKUP($P6,$B$4:$J$300,2,FALSE)))
 
Upvote 0

Forum statistics

Threads
1,213,521
Messages
6,114,104
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top