Our mission is to categorize the properties into 3 groups. In a new sheet, add the types of properties.
Categorize them into 3 groups, Home, Apartment, and Studio.
We look for this value.
The range is the table we have created in a new sheet.
We need to return the second column.
Type FALSE to exact match search.
Copy the formula down.