Correlate data on 2 sheets

[aleacast]

Hello,

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:

Alessandro

Mario

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 · Accepted solution]

@aleacast 

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, "")

Otherwise:

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

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

[#3]

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