I am trying to search for multiple text fields in column A and once they are all found in one cell, return the value of the next cell in column B.
Example:
I want to search for 10#, TALL, BOWL, and BLUE in column A and once all of them are found in one cell, return the Product No that is in...