SOLVED

Linking Data Accross Tabs

Copper Contributor

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!

5 Replies

@escramer93 

That's XLOOKUP(), VLOOKUP() or INDEX/MATCH. Could you provide small sample file to illustrate how it could be done?

@Sergei Baklan added to original post! Thank you!

best response confirmed by escramer93 (Copper Contributor)
Solution

@escramer93 

Thank you. That also depends on which version of Excel you are could be. Some variant could be (same sequence as here)

image.png

=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)

@Sergei Baklan Thank you very much you just saved me a lot of time!

@escramer93 , you are welcome, glad to help

1 best response

Accepted Solutions
best response confirmed by escramer93 (Copper Contributor)
Solution

@escramer93 

Thank you. That also depends on which version of Excel you are could be. Some variant could be (same sequence as here)

image.png

=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)

View solution in original post