Home

Excel drop down selection with multiple outputs

Highlighted
Carl Hiler
Occasional Visitor

Excel drop down selection with multiple outputs

Hello I'm stumped on this issue.

In excel I have a drop down list of Cartons like 100-199 200-299 300-399 etc.

That works fine except I have three other list beside it that I'm trying to get output to main page from carton selection of all the three other column's in the same row as the selected carton range and transfer each of the cells value in three different cells on main page.

This would simplify this project by not having to select each 4 drop down when one could transfer to all four cells.

1 Reply

Re: Excel drop down selection with multiple outputs

Have you tried Index & Match formula?

Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
44 Replies
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777 in Excel on
47 Replies
Split data from one column into two columns
Jonni Anderson in Excel on
6 Replies
align decimals in a column
Jonni Anderson in Excel on
15 Replies
blink a cell
Lorenzo Kim in Excel on
12 Replies
Missing Excel 2013 worksheet tabs
Mike Hill in Excel on
7 Replies