Forum Discussion
Find and Replace Consecutive Cells
I'm a bit of a novice in Excel and using 2013 Home & Student. I have a large file containing 26 sheets - each with hundreds of rows - in which I'm attempting to find specific values in consecutive ce...
erol sinan zorlu Ah, good point. I had been going at it from a Find & Replace perspective, so I hadn't considered circular reference using functions.
With that in mind, I guess my questions boils down to: is there a way to use Find and Replace to search two cells at once?
for example IF(AND(A1="something",B1="Anotherthing"),"Desired Value If condition is true",__PUT ANOTHER IF HERE IF YOU HAVE MORE CONDITIONS or put "" to keep cells empty__)