Forum Discussion
Finding a "2 cell" name in anther sheet and copying data
Hello- I'm looking for a formula to enter in column D of the Main Sheet. I would like to find the "Total" in sheet: 2023 for the name in cells A&B, and copy them into the Main Sheet. The names...
Hi
In your 'Main' sheet cell E2 then copy down:
=XLOOKUP( A2 & B2, '2023'!A$2:A$9 & '2023'!B$2:B$9, '2023'!F$2:F$9, "no match" )Assuming there's no space anywhere around '2023' in your other sheet name
In case there would be any extra spaces in your 'Main' and/or '2023' sheets, columns [First Name] and [Last Name] use :
=XLOOKUP( TRIM(A2 & B2), TRIM('2023'!A$2:A$9 & '2023'!B$2:B$9), '2023'!F$2:F$9, "no match" )