Hi guys,
I am doing a project in which I I have a drop down that chooses from a lists of names on a table, and I want for the drop down to fill in the rest of the table with a vlookup.
I attached a demo of the spreadsheet.
Sp basically I want the information from the data tab to populate in each column when I choose the client name.
Also, the names duplicate in the drop down.
Eventually this will be a Power Query project .
Hi Robert
Give this a try. The ranges are not dynamic so you will need to adjust them to your needs.
Please note that the formulas are array formulas.
I have temporarily used a PivotTable to get the unique name from the data for the Data Validation list.
Good luck
Sunny
Thanks Sunny!
This is perfect.
Hi Sunny,
Actually I have a question. I am trying to get the formula to work on a data sheet feeding from a query. Will the formula change if I am using a query sheet?
I'm having issues copying the formula to the final project.
Hi Robert
I am not familiar with QUERY. Maybe others may be able to help.
Sorry.
Thanks Sunny,
Actually the issue was that I wasn't closing the array with ctrl+shift+enter.
Did that and it worked. Thanks again!
