Please help, I have two ways to search, one time works, one time another. I would like to combine these methods to increase the number of items that could be found. What formula to do this? I assume you will need to add an additional column that will combine both search results.
Any help will be rewarding. Cells marked in yellow equal to Nan