Hi Forum,
I want to find a specific value in a cell from a column of long text in another cell using vlookup function (I believe this is the best one). The return value would be any indication that the value is contained in that column of long texts. Below is an example:
Find "Mary" from C2 in D3:D30, D3 = "Mary had a little lamb" , D4 = "Where is Mary?" = Return value would be "Yes" or "No" Mary is contain in D3:D30 of texts.
Return Values Scenarios
1) Yes or No
2) Count of how many times the value is, 2 times in this example
3) Return of ID of rows Mary is mentioned, D4 and D3
Thanks Forum.
Bookmarks