• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

What are the common usage of Index Match function

yasir

New Member
Dear All,

I have read that the Index and Match function is one of the most useful function in Excel. I have tried to learn about Index and match function in web a lot but i did not understand that as it is a wonderful function in excel.

I know well lookup functions and uses for comparing data, finding missing data etc..


Could you please give some common usage of index match which I can use in my works and also please explain me what index match do better than Vlookups..


Thanks,

Yasir
 
Yasir


Match returns the position of an item in a range/array


Index looks up a 2D range and can return a value from a position in the range


Hence you often use them together so that Match will search the header for a value and then return a value from a row in the same position as the header value.

Index can hence have a Match in both the Row and Column positions giving it a lot of flexibility.


Refer:

http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/

and

http://www.excelhero.com/blog/2011/03/the-imposing-index.html
 
Back
Top