Forum Discussion
kmarkgraf
Apr 12, 2024Copper Contributor
How do I match data from two tabs then pull data from one sheet to the other?
I have two tabs that are similar, just with updated information from each quarter. I am looking up the unique identifier in column C in tab 1 to match to the previous quarter in tab 2. If there is a ...
HansVogelaar
Apr 12, 2024MVP
In A2 on tab 1:
=XLOOKUP(C2, 'tab 2'!C:C, 'tab 2'A:A, "")
Replace tab 2 with the real name of that sheet.
Fill down.