Forum Discussion
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...
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.