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)
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!
escramer93 , you are welcome, glad to help