SOLVED

CATEGORIES

Occasional Contributor

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 Replies
best response confirmed by apo114 (Occasional Contributor)
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.

Thanks, it works