Hello,
I am new to this forum and would like to thank you very much for all yours contributions to a forum like this.
I am build a excel a sheet with but some how my index function does not work in a particular cell,like as what I want. may be I am using wrong function and please help me to clarify this issue.
details are below
Sheet 1
A B C D E F
Name Code Subject Grade Class 1 Class 2
Mary ENG English 1,2&3 period 1 Period 2
Maria GEO Geography 3&4 Period 2 Period 1
Sheet 2
A B C D
Name Period 1 Period 2 Period 3
Mary
Maria
So I want fill on sheet 2 column B under period 1 to the selection on Sheet 1's E column "Class" name.
formula I used on Sheet 2 column B, C & D : =INDEX(sheet1!E2:F2,MATCH(A2,sheet1!A2:A3,0),MATCH(B2,sheet!E2:F2,0))
but it shows #NUM! error.
Bookmarks