noslenwerd
Board Regular
- Joined
- Nov 12, 2019
- Messages
- 85
- Office Version
- 365
Hello,
In the example below, in cell c2, I am trying to search for "Red Apple" (C1), in the cell A3. If it is found, I want C3 to populate with a 1. If it is not, show a 0. As you can see below, it isn't working currently.
Any ideas what is wrong with my formula?
In the example below, in cell c2, I am trying to search for "Red Apple" (C1), in the cell A3. If it is found, I want C3 to populate with a 1. If it is not, show a 0. As you can see below, it isn't working currently.
Any ideas what is wrong with my formula?