Forum Discussion
Solved
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...
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.
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!
It's working perfecly, thank you so much for your response, quick & clear.. You saved me a LOT of time!