Forum Discussion
Solved
Need to Populate Multiple Columns From Separate Sheet
I am trying to populate 3 columns with manager names found in a separate Excel sheet. These three columns are split according to the seniority of the manager. These are split as 'T1 Manager', 'T2 Man...
XLOOKUP or VLOOKUP. You have some options.
XLOOKUP:
=TEXT(XLOOKUP(A2,Sheet2!$A$2:$A$4,Sheet2!$B$2:$D$4,""),";;")VLOOKUP:
=TEXT(VLOOKUP(A2,Sheet2!$A$2:$D$4,{2,3,4},0),";;")
XLOOKUP or VLOOKUP. You have some options.
XLOOKUP:
=TEXT(XLOOKUP(A2,Sheet2!$A$2:$A$4,Sheet2!$B$2:$D$4,""),";;")
VLOOKUP:
=TEXT(VLOOKUP(A2,Sheet2!$A$2:$D$4,{2,3,4},0),";;")
Thank you very much.
- You are welcome!