Forum Discussion
Correlate data on 2 sheets
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?
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.
2 Replies
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!
