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...
You can try XLOOKUP() in this way-
=XLOOKUP(1,(A2='2023'!$A$2:$A$9)*(B2='2023'!$B$2:$B$9),'2023'!$F$2:$F$9,"")Or FILTER() function
=@FILTER('2023'!$F$2:$F$9,('2023'!$A$2:$A$9=A2)*('2023'!$B$2:$B$9=B2),"")Spill version of formula-
=MAP(A2:A9,B2:B9,LAMBDA(a,b,@FILTER('2023'!F2:F5000,('2023'!A2:A5000=a)*('2023'!B2:B5000=b),"")))