Dec 17 2020 09:51 AM - edited Dec 17 2020 10:12 AM
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!
Dec 17 2020 09:54 AM
That's XLOOKUP(), VLOOKUP() or INDEX/MATCH. Could you provide small sample file to illustrate how it could be done?
Dec 17 2020 10:13 AM
@Sergei Baklan added to original post! Thank you!
Dec 17 2020 11:44 AM
SolutionThank 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)
Dec 18 2020 01:59 PM
@Sergei Baklan Thank you very much you just saved me a lot of time!
Dec 17 2020 11:44 AM
SolutionThank 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)