Hi there, I have a spreadsheet with a lot of data. I'm trying to search cells in a column to see if specific info is present and then return all values in another correlated cell.
Here is an example of the data
What I need to do is search the first column for a specific value, in this case the words "sailing on a boat" and return every SKU where those words are present.
As you can see, I have the term that needs to be searched for, and the corresponding SKU. The number of SKUs that will be returned will vary and the list of Data is quite long.
Thank you in advance for any help.
Here is an example of the data
Data | Misc Data | SKU |
I like to go sailing on a boat on the weekends | Misc data 1 | 23DSF33JY |
My dad loves to play soccer | Misc data 2 | 4567HGDDD22 |
Fishing while sailing on a boat is the best | Misc data 3 | CV567FGH |
What I need to do is search the first column for a specific value, in this case the words "sailing on a boat" and return every SKU where those words are present.
sailing on a boat |
23DSF33JY |
CV567FGH |
As you can see, I have the term that needs to be searched for, and the corresponding SKU. The number of SKUs that will be returned will vary and the list of Data is quite long.
Thank you in advance for any help.