flawrence3101
New Member
- Joined
- Nov 8, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I am trying to create a custom function. I want the program to loop through all the entries in column A. The formula is:
=INDEX(Category,MATCH(TRUE,ISNUMBER(SEARCH(Keyword, Description)),0))
The table is:
A B C
Description Keyword Category
Kroger store #1 Kroger Food
Exxon store #2 Exxon Auto
CVS store 3 Healthcare Prescriptions
The list of descriptions is around 240 rows. Each column is a named range.
Any help would be appreciated.
=INDEX(Category,MATCH(TRUE,ISNUMBER(SEARCH(Keyword, Description)),0))
The table is:
A B C
Description Keyword Category
Kroger store #1 Kroger Food
Exxon store #2 Exxon Auto
CVS store 3 Healthcare Prescriptions
The list of descriptions is around 240 rows. Each column is a named range.
Any help would be appreciated.