Forum Discussion

Copper Contributor

Nov 20, 2023

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

excel

Formulas and Functions

HansVogelaar
Nov 20, 2023
jmccarron

In G2:

=XLOOKUP(F2, Table3[Course Prefix], Table3[[College]:[Department]], "")

Fill down.

jmccarron

Copper Contributor

Nov 20, 2023

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

HansVogelaar

MVP

Nov 20, 2023

jmccarron

In G2:

=XLOOKUP(F2, Table3[Course Prefix], Table3[[College]:[Department]], "")

Fill down.

jmccarron
Copper Contributor
Nov 20, 2023
That worked beautifully. Thank you, Hans!