I have an example excel file attached.
I have an array formula set up in K3:K6...
The formula does search (even a partial search) for the text that is in B3 and searches for this text in F1:F26, and then displays the corresponding url from H1:H26. If it finds multiple instances of the searched word it displays multiple corresponding urls.
How can I modify the formula so that instead of only searching for anything found in B3, the formula will also search for anything in C3, or D3....
So in the example the formula only searches for "H240" and displays the corresponding url....
How can I make the formula search for "H240" or "rope" or "black", and display any urls that match either of the three words.
I think it is something simple, I tried using for a range of cells in the search function but that didn't work. I also tried explicitly placing the 3 words in the formula and that worked, however I would like for it to link to the 3 cells so that it dynamically updates.
Thank You for your help!
Bookmarks