Hi,
I need a formula to return a certain value if another cell returns a certain value. I can see heaps of formulas online, but this seems to be only if the cell has text in it. My cell has a formula picking up results from another sheet.
So I need a formal in Column D to say "Open" or "Closed" is the formula in G returns a value that contains the letters "CONTIN". The returned value on Column G will show a result of "AEC ANZ-CONTIN-002528", but this number will keep changing, only the element "CONTIN" is consitent.
Hope this makes sense, but all thng i have tried seems to look at the formula in Column G, not the returned value, so I cant make it work.
Thanks,
Rod.
I need a formula to return a certain value if another cell returns a certain value. I can see heaps of formulas online, but this seems to be only if the cell has text in it. My cell has a formula picking up results from another sheet.
So I need a formal in Column D to say "Open" or "Closed" is the formula in G returns a value that contains the letters "CONTIN". The returned value on Column G will show a result of "AEC ANZ-CONTIN-002528", but this number will keep changing, only the element "CONTIN" is consitent.
Hope this makes sense, but all thng i have tried seems to look at the formula in Column G, not the returned value, so I cant make it work.
Thanks,
Rod.