Index and match

Hi ,

I am learning to use the index and match worksheet functions.

I read through some examples and tried to set up a spreadsheet as attached.

For some reason, it is working only partially. For some cells the value is returning correctly and in some it is returing #ref.

Can somebody let me know what is it that I am doing wrong? I am not sure where my understanding went wrong.

Thanks n advance for your help,

jf