Get the MARK value base on the unique NO. & Code

[jasond1992]

Get the MARK value base on the unique NO. & Code

Hi there good afternoon can i ask some help about my problem. how to get the Marks value base on the unique No. and CODE No.

"Data" is the source data marks value
"Sheet2" is the formula will input

Please see the attached image for the expected result.

Data Source
DATA Source.PNG

Expected Result
Expected Result.PNG

[Glenn Kennedy]

One way:

=IFERROR(INDEX(Data!$D$2:$D$1000,MATCH(1,INDEX((Data!$D$2:$D$1000<>"")*(Data!$C$2:$C$1000=F3)*(Data!$B$2:$B$1000=E3),0),0)),"")

copied down.

[jasond1992]

One way:

=IFERROR(INDEX(Data!$D$2:$D$1000,MATCH(1,INDEX((Data!$D$2:$D$1000<>"")*(Data!$C$2:$C$1000=F3)*(Data!$B$2:$B$1000=E3),0),0)),"")

copied down.

Nice it's working Thank you so much sir. GOD Bless. I'll give you reputation.

[Glenn Kennedy]

You're welcome & thanks for the feedback.