Forum Discussion

azzwuff's avatar
azzwuff
Copper Contributor
May 23, 2024

Populate Cells from another sheet based on dropdown selection

Hi All     Thanks for taking the time to read this, unfortunately I'm unable to achieve what i would like so hopefully someone can help. I would like to populate two different cells from whichever ...
excel
Formulas and Functions
SnowMan55's avatar
SnowMan55
Bronze Contributor
May 23, 2024

azzwuff 

You should be able to achieve the desired results using one of the Data validation features (under the Data menu) for the dropdown list, and formulas using XLOOKUP for the lookup and retrieval of data.  See the attached workbook, especially the _Info worksheet.

Resources