Forum Discussion
BronWalker
Jun 26, 2024Copper Contributor
Forumlas to use for horizontal data entry
Hello, I am trying to create a spreadsheet that will use a master list of data across two columns and then sync with other pages in the same workbook to produce mini lists for each subset of dat...
Martin_Angosto
Jun 26, 2024Iron Contributor
Not as fancy as you have described, but for autocompletion purposes you can use an INDEX/MATCH formulation.
Please see attached workbook with proposed solution.