SOLVED

Correlate data on 2 sheets

New Contributor

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 Replies
best response confirmed by aleacast (New Contributor)
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.

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