Forum Discussion
Solved
Autofill Multiple Columns Based on Table Data
I am trying to come up with a solution to autofill multiple cells based on text input to a specific cell. I want to be able to type in a department prefix into column F and then have columns G...
Any of lookup functions shall work. Perhaps you may share small sample file with the table from which you try to pickup data.
Hello Sergei,
Thank you for your response. I am sure the lookup functions will work, it is most likely that I am making a mistake in my formula. Here is a link to a small sample file:
https://auspartans-my.sharepoint.com/:x:/g/personal/jmccarron_aurora_edu/EW9oCP5cn99IobOLKY4z7DwBKv3fdvceh20StlcxgAgT3g?e=Zbpnt7
Unfortunately you didn't share the file for everyone, it requires credentials.
- Ah, I was worried about that. The permissions are locked by our organization. This should hopefully work:
https://www.dropbox.com/scl/fi/apfkvgcme53jgrymjp5uf/Sample-Worksheet-Course-Data.xlsx?rlkey=75uimtnb1z4n2lf2yxi2nd7tb&dl=0
