Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
liviaboscuCopper ContributorMar 12, 2024Excel function Hello, I'm looking for a function in Excel. I have 3 sheets: - 1st sheet: a list of items and the names of them - 2nd sheet: same as 1st sheet - 3rd sheet: a summary of all the unique item...Show More
Detlef_LewinSilver ContributorMar 12, 2024liviaboscu Something like this:=XLOOKUP(from_sheet1)&XLOOKUP(from_sheet2)
