Correlate data on 2 sheets

New Contributor


I have an Excel sheet with a list of participants to an event. I have another Excel sheet some of those participants, and the response if they participate to the event (yes/no).

I would like to bring the response in the first sheet.


Example Sheet 1:




Example Sheet 2:

Alessandro Yes

Mario No


I would like Sheet 1 to have:

Alessandro Yes

Mario No


Is there a formula to automate this?


2 Replies
best response confirmed by aleacast (New Contributor)


Assuming that the names are in column A on both sheets, and the responses in column B, enter the following formula in B2 on Sheet 1.

If you have Microsoft 365 or Office 2021:


=XLOOKUP(A2, 'Sheet 2'!A:A, 'Sheet 2'!B:B, "")




=IFERROR(VLOOKUP(A2, 'Sheet 2'!A:B, 2, FALSE), "")


Change Sheet 2 to the actual name of that sheet, then fill down.

It's working perfecly, thank you so much for your response, quick & clear.. You saved me a LOT of time!