Hey forum,
I've been nesting a couple of IF statements and using the ISTEXT(SEARCH as part of the AND condition in those IF statements but the result seems to be coming back as the opposite to what I'm expecting it to return.
This is what I've been trying to get to work:
=IF(AND(E5=Tracking!C33,ISTEXT(SEARCH(“L”,Tracking!D33))),E5,G5)
Cell E5 does equal 'Tracking!C33' and the cell 'Tracking!D33' does contain an "L".
If I'm reading it right (which apparently I don't seem to be haha), that would return the value of E5 yes?
The issue I'm having is that it is returning the value of G5 instead when all the conditions in the AND statement are true.
Can someone point out what I've got wrong please or offer some advice or a different way to do it?
Many thanks in advance.
Bookmarks