Forum Discussion
IF Nested Error Help
Ok, so I have searched this site and must have checked out 20 different discussions in regard to the IF function and alternatives, however it seems that in most instances it is for financial. I am tr...
=INDEX(Sheet2!A:A,MATCH($C$5,Sheet2!A:A,0)+1)Does this return the expected result? This is the formula in cell A19 the formulas for A21, A23, A25, A27 and A29 are in the attached file.
=INDEX(Sheet2!A:A,MATCH($C$5,Sheet2!A:A,0)+1)Does this return the expected result? This is the formula in cell A19 the formulas for A21, A23, A25, A27 and A29 are in the attached file.
That does, thank you very much! I feel like I have used this formula before and appreciate you "reminding" me how it works.
