Jazzzola324
New Member
- Joined
- Jun 1, 2019
- Messages
- 7
Hello,
I am trying to figure out a formula which will search a separate sheet for four different phases. Then, display the one phrase that is in the sheet.
I need to search the exact phrase and the cells it is search will only contain that phrase ( i.e. I’m not search a paragraph of text)
I tried combining IF and INDEX, but that didn’t work.
any help you can give will be much appreciated
I am trying to figure out a formula which will search a separate sheet for four different phases. Then, display the one phrase that is in the sheet.
I need to search the exact phrase and the cells it is search will only contain that phrase ( i.e. I’m not search a paragraph of text)
I tried combining IF and INDEX, but that didn’t work.
any help you can give will be much appreciated