Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Lookup if matching word found in category list?

Topic Labels: Formulas
254 0
Showing results for 
Search instead for 
Did you mean: 

I have a list of titles that I want to find the ranking for. For instance, “CEO” is “C Suite”, “Director of Sales” is “Director”, etc… I have a list of potential matches for these categories. For instance, 30 titles that fall under “Manager”, 21 titles that fall under “C Suite”, and so on.

How can I make a column to find the appropriate category for a title in Airtable? In Google Sheets this can be achieved with a query function, but I’m not too much of an excel wizard - so any and all help greatly appreciated!

0 Replies 0