Hi,
I am trying to values in a column if a word appears in a string of text in another column
for example
Column A
Row 1 Here is an apple
Row 2 here is a banana
Row 3 The apple is green
Row 4 Strawberries are red
Row 5 It is apple flavoured
Row 6 Here is an orange
Column B
Row 1 £5
Row 2 £12
Row 3 £10
Row 4 £7
Row 5 £1
Row 6 £17
Column C
Row 1 01/08/2019
Row 2 25/03/2020
Row 3 30/02/2019
Row 4 05/11/2019
Row 5 17/07/2020
Row 6 22/11/2019
I would like to produce a list of data showing all instances of apples, showing corresponding dates and amounts. I don't even know where to begin? Should I use a vlookup or a filter function?
example worksheet attached. The cells highlighted in yellow is what I'm trying to achieve please
Bookmarks