maximillianrg
Board Regular
- Joined
- Aug 7, 2014
- Messages
- 74
- Office Version
- 2016
- Platform
- Windows
Hello Excel Masters
While Power Query with Fuzzy lookup is great for a lot of work I'm doing, I'm hoping for some help with a searching formula
Sheet 1 Cell A1 = "cat"
Sheet 2 Column A cells A1 - A2000 contain text that ranges from 1-15 words
In Sheet 1 cell A1 I'm looking for a formula that would do the following:
1. Search for the word in Sheet 1 cell A1 in Sheet 2 Column A
2. If no hits are found return 0
3. If more than one instance is found return "Multiple"
4. If only once instance is found return the cell reference that it was found in
Is that possible?
While Power Query with Fuzzy lookup is great for a lot of work I'm doing, I'm hoping for some help with a searching formula
Sheet 1 Cell A1 = "cat"
Sheet 2 Column A cells A1 - A2000 contain text that ranges from 1-15 words
In Sheet 1 cell A1 I'm looking for a formula that would do the following:
1. Search for the word in Sheet 1 cell A1 in Sheet 2 Column A
2. If no hits are found return 0
3. If more than one instance is found return "Multiple"
4. If only once instance is found return the cell reference that it was found in
Is that possible?