Forum Discussion
Formula Help
I was trying to use XLOOKUP formula, but it is not working, and I think I know why, I just need help with finding the right formula for the job. Attached is an example workbook with my question. Than...
catherine9910 As a variant, in E2 and fill down:
=INDEX('Manager Groups'!$A$1:$H$1,,SUM(--('Manager Groups'!$A$2:$H$3=A2)*COLUMN('Manager Groups'!$B$1:$I$1)))