OFFSET + MATCH Function in Excel

Показать описание

Hello Friend,

In this video you will learn how to use OFFSET function in place of VLOOKUP. I have used OFFSET + MATCH Function here.

Please download this excel file from below given link:

Watch the best info-graphics and dynamic charts from below link:

Follow me on Facebook:

Telegram:

blogger:

Рекомендации по теме

Комментарии

Hi PK. Thanks for the great video. Was very helpful.

arunleslie

Thanks for the clarity. Helps for my application.

querrythis

Very Helpful. Like your videos PK. Keep up the good work.

ramdeshpande

Best regards from Noida, keep up the good work

pramodparnami

Thank you my friend. This really helped me.

tonianibal

Hi, in match formula can we specify the column range of a particular table
i want to change the column range selection for different tables in same formula
please reply

amolpawar

Hello PK, Nice Job, well-done. How to offset a table not a range, and change the value of a cell in same raw?

abdulrahmanalthunayan

Hello Pk, nice video. But, the second "-1" is useless. You can just put the range "b1:d1"

eduardosemj

So the Offset function formula is =Offset(Reference, Rows, Cols)
Reference is the a cell reference to a cell containing the values that you are searching for.
Rows decides the vertical Offset, negative values moves down and positive values move up.
Cols decides the horizontal Offset, negative values moves left and positive values move right.

So in the video the first match part finds the vertical position of the thing being searched for. Adding or subtracting from this will move the offset up or down.

And the second part finds the horizontal position of the thing being searched for. Adding or subtracting from this will move the offset right or left.

jackmckeown