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...
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- That worked beautifully. Thank you, Hans!