• 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.

Index with Match formula

S

sachar

Member
Dear All,

With reference to the following formula that I used in the attached sample file. Can you please elaborate the logic of “1” highlighted with red colour?

upload_2017-4-26_11-34-26.png
 

Attachments

  • Complimentary Summary_catogry in row_practice_vlookup.xlsx
    40.8 KB · Views: 10
Hi !

There is no logic but just a value as you must read yourself
in Excel inner help of MATCH worksheet function !

The logic is the way of its use within a formula …
​
 

Did you open at least Excel inner help of MATCH worksheet function
and read it ?! As everything is explained there …​
 
You must log in or register to reply here.
Back
Top