TailsFails1979
New Member
- Joined
- Aug 20, 2019
- Messages
- 4
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, however Column A-D is a pivot table and there is a possibility that Pineapples moves from Column D to Column C, so it needs to be flexible enough to first of all find Pineapples, then go down in that column and complete the Yes or No part of the formula.
Lastly - if the formula is flexible enough - i will also put in Column G the same formula but search for Peaches, and so on
Any help is appreciated
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, however Column A-D is a pivot table and there is a possibility that Pineapples moves from Column D to Column C, so it needs to be flexible enough to first of all find Pineapples, then go down in that column and complete the Yes or No part of the formula.
Lastly - if the formula is flexible enough - i will also put in Column G the same formula but search for Peaches, and so on
Any help is appreciated