Forum Discussion
Solved
IF AND EXACT formula with two conditions
Can someone help create above formula? I need to input a formula in Column J. It needs to look at both Columns I and O. If Column O has the words "Opt-Out" within it, then this is the secondary crite...
In J2:
=INDEX('Shift Diffs'!$C$2:$C$7, I2+3*ISNUMBER(FIND("Opt-Out", O2)))
Fill down.
In J2:
=INDEX('Shift Diffs'!$C$2:$C$7, I2+3*ISNUMBER(FIND("Opt-Out", O2)))
Fill down.
- Genius. TY!
