• 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


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

Index Match not working


Excel Ninja
An answer to Your question:

MATCH(lookup_value, lookup_array, [match_type])
The MATCH function syntax has the following arguments:

  • lookup_value Required. The value that you want to match in lookup_array. For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want.
    The lookup_value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.


Dear Sir,
Thanks for your reply, I tried the way you explained the match formula but still its not working.


Active Member
Try =INDEX(Sheet2!$C$2:$C$26,MATCH(Sheet1!$B2,Sheet2!$B$2:$B$26,0))
Adapt range as needed, do NOT use entire columns reference, it is bad practice !