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...
=IF(NOT(ISNA(VLOOKUP(A2,CHOOSE({1,2},'Manager Groups'!$A$2:$A$3,'Manager Groups'!$B$1),2,0))),VLOOKUP(A2,CHOOSE({1,2},'Manager Groups'!$A$2:$A$3,'Manager Groups'!$B$1),2,0),IF(NOT(ISNA(VLOOKUP(A2,CHOOSE({1,2},'Manager Groups'!$D$2:$D$3,'Manager Groups'!$E$1),2,0))),VLOOKUP(A2,CHOOSE({1,2},'Manager Groups'!$D$2:$D$3,'Manager Groups'!$E$1),2,0),IF(NOT(ISNA(VLOOKUP(A2,CHOOSE({1,2},'Manager Groups'!$G$2:$G$3,'Manager Groups'!$H$1),2,0))),VLOOKUP(A2,CHOOSE({1,2},'Manager Groups'!$G$2:$G$3,'Manager Groups'!$H$1),2,0))))Maybe this formula does what you want to do.