Forum Discussion
Solved
Linking Data Accross Tabs
Hello! I am trying to match up data from one column in sheet A that shows the name of a person and match that with the identical name from a sheet B. I would then want it to reference the value from a different column in sheet B and pull that info into a column in Sheet A. Any help here would be greatly appreciated!
Thank you. That also depends on which version of Excel you are could be. Some variant could be (same sequence as here)
=XLOOKUP(A2,Sheet2!A:A,Sheet2!B:F) -- =INDEX(Sheet2!B:F, MATCH(Sheet1!A3,Sheet2!A:A,0),0) -- =INDEX(Sheet2!$B:$F, MATCH($A4,Sheet2!$A:$A,0),MATCH(C$1,Sheet2!$B$1:$F$1,0)) (this one drag to the right)
5 Replies
That's XLOOKUP(), VLOOKUP() or INDEX/MATCH. Could you provide small sample file to illustrate how it could be done?
SergeiBaklan added to original post! Thank you!
Thank you. That also depends on which version of Excel you are could be. Some variant could be (same sequence as here)
=XLOOKUP(A2,Sheet2!A:A,Sheet2!B:F) -- =INDEX(Sheet2!B:F, MATCH(Sheet1!A3,Sheet2!A:A,0),0) -- =INDEX(Sheet2!$B:$F, MATCH($A4,Sheet2!$A:$A,0),MATCH(C$1,Sheet2!$B$1:$F$1,0)) (this one drag to the right)
