Pick Lists - Data Validation

Copper Contributor

I want to be able to create a pick list which if chosen populates a number of columns with key information.

It's for a recipe template I am doing so when I pick an ingredient, I want it to complete other columns about that ingredient - nutritional data, pricing etc
I can only seem to use Data Validation to fill in one column.

Can anyone help?

2 Replies


Assuming that you have a range or table with ingredients in its first column, and additional information such as nutritional data etc. in other columns, you can use the XLOOKUP function or if you have an older version of Excel, the VLOOKUP function to return that info based on the selection in the drop-down list.

Thank you @HansVogelaar - I will try that :)