Forum Discussion
Help rewriting formula to increase by 10 cells
Hello, I'd like help rewriting this formula so it will increase the reference cells by ten rather than one when I drag down. =IFERROR(LOOKUP(2,1/(ISNUMBER('PATIENT TRACKING'!I4:I13)),'PATIENT...
Unfortunately this did not work, but it seemed close. It referenced the wrong data.
As in the sample attached it works. Or I misunderstood your logic.