CATEGORIES

[apo114]

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".

[#2 · Accepted solution]

@apo114 

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.

[#3]

Thanks, it works