Howdy,
Hopefully an easy one.
See the attached data sheet.
What i am trying to do is in Column F Starting at F3 i want a formula that can do the following
1. Find the word Pineapples
2. Look down the Pineapples Column and if there is a 1 return 'Yes' or a 0 return 'No'
That is the easy bit...