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)


In B2, if you have Microsoft 365 or Office 2021:


If you have an older version:


Fill or copy down.

Thanks, it works