Offset formula

[Jayadev Sarangi]

Hello,

Please guide me on offset formula.

Regards
Jay

 

[vijay.vizzu]

Dear Jayadev

Can you please elaborate more about your requirement. If you want to learn offset formula, this site has so much stuff. Just search offset within this site, you will find more about offset along with some cool tips & tricks

 

[Smallman]

Jayadev

What more specifically are you after as the Offset formula is a Volatile one and often best to use alternatives. What are you trying to achieve?

Smallman

 

[Hui]

I'd start with these two posts:
http://chandoo.org/wp/2012/09/17/offset-formula-explained/
http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/

You should also be aware that overuse of Offset can under some circumstances severely impact Excel's performance, hence the concern from the previous two posts

But just using a few here and there will have minimal to no impact on Excel's performance

 

[Jayadev Sarangi]

Thanks all. I think I got it.

Regards
Jay