Forum Discussion

kmarkgraf's avatar
kmarkgraf
Copper Contributor
Apr 12, 2024

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 match, I want the information from column A in tab 2 to pull over to column A in tab 1. I have tried a bunch of different combinations but nothing is working. Please help! Thank you!

Formulas and Functions

2 Replies

  • Yea_So's avatar
    Yea_So
    Bronze Contributor
    Apr 15, 2024
    Do you have a sample file so everyone on here can suggest the solution for you and you can just pick which one you like best?
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 12, 2024

    kmarkgraf 

    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.