Hi,
In the attached workbook i have a formula that will say, if col a is yes, lookup col b in a required fields mapping and if the relevant column has 'X' in it then return column c.
I have added a hard coded version of what i need to pull from the string of text and what the formula currently pulls in.
In the formula returned cell i need it to identify weather the string of text in col c has either "CALL" or "PUT", which ever one it has it needs to return it (Call or PUT)
Any ideas how i can add this to the formula?
Bookmarks