Forum Discussion
Solved
CATEGORIES
1. The excel spread sheet is attached
2. In the sheet "CATEGORY", categories where the units belong to are listed. In the sheet "DATA", in column B I request a formula to identify where the units of column a belong to according to the sheet "CATEGORY".
In B2, if you have Microsoft 365 or Office 2021:
=XLOOKUP(A2,CATEGORY!$B$2:$B$8,CATEGORY!$A$2:$A$8,"")
If you have an older version:
=IFERROR(INDEX(CATEGORY!$A$2:$A$8,MATCH(A2,CATEGORY!$B$2:$B$8,0)),"")
Fill or copy down.
In B2, if you have Microsoft 365 or Office 2021:
=XLOOKUP(A2,CATEGORY!$B$2:$B$8,CATEGORY!$A$2:$A$8,"")
If you have an older version:
=IFERROR(INDEX(CATEGORY!$A$2:$A$8,MATCH(A2,CATEGORY!$B$2:$B$8,0)),"")
Fill or copy down.
- Thanks, it works
