Had a question. I am trying to create a formula that allows me to search for MULTIPLE specific text within a column and have it spit out the appropriate information: Here is my issue.
Col A Col B
What I am trying to do is create an if statement that will look for the size within Column B (Zone) and spit out the appropriate size! I attempted to create it with the following formula:
The problem is this only helps me locate ONE of the sizes (160x600). I need the formula to be able to identify all three sizes at the same time!(300x250,300x600) Is it a matter of using the OR statement within the IF formula?