MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can I use offset in formulas?


Posted by Yin Mi Zhi on January 11, 2001 1:56 AM

If I want to have a formula like =D(1+C3) where C3=5 giving the value in cell D6 how do I write this in Excel please.

Thank-you.

Yin


Posted by Mark W. on January 11, 2001 3:30 AM

=INDIRECT("D"&C3+1)

Posted by Yin Mi Zhi on January 11, 2001 10:18 PM

Duo xie, many thanks.