Offset more than a lookup function..

Excel Offset

Hey guys thanks for coming here.. I am so happy with the response I am getting from you guys.

If you are into Excel VBA learner then please watch this video start to end to have better understanding..
 Programming Basics of Windows
 







Let's start:-  

What is Offset?
Ok, if you just go by the meaning, it means anything which is already set somewhere (in Excel it means cell reference) and move it from that place to any where. So it means Off (change the position) + Set (default position)

Why Offset?

In Excel there are lots of lookup function and the users who are good in these functions, will use most of the time Index + Match to achieve desired result. Now the Offset is more advance form of Index + Match.

• Index + Match = Combination of 2 formulas ( you can not use them separately), Real power is only when you use both of them together, they share very good relationship :).
• Offset = Technically it is single formula but it uses 5 inputs out of 4 MAY come from different formulas. Now comparison  is very easy what you can achieve with any lookup function you can also get that using Offset.

Offset Syntax?

Reference - This is default cell address, which will be used to calculate rows and columns offset value. See below..

 

Rows - When you select reference, then you need to mention how many rows do you want to move.

see below..

Cols - Exactly same but not with rows this will work with columns ( I have video below for more info).

Height - This is optional. It will extend the area of your selection either in upward or downward.

Width - This is also optional. It will extend the area of your selection either on left  or right direction.

see below.

I know this is not the complete info so I would request you to see my video based on offset, where you will relate everything so easily. 

Please subscribe my channel and like the video. Please also share your feedback in comments.
Looking forward for your response..
AutoMateSheets - Channel Link
Excel Offset - YouTube Link

For any query please feel free to right lkthecool@gmail.com 

Thanks
Lokesh K