Index with Match formula

[sachar]

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?

 

[Marc L]

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 …
​

 

[sachar]

Dear,

This is not clear to me itself, I am looking first time!

 

[Marc L]

Did you open at least Excel inner help of MATCH worksheet function
and read it ?! As everything is explained there …​