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 ...
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)
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)SergeiBaklan Thank you very much you just saved me a lot of time!
