Lookup Different Values in Different Column

[animas]

<TABLE style="WIDTH: 336pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=447 border=0><COLGROUP><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width=57><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1609" width=44><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1645" width=45><COL style="WIDTH: 226pt; mso-width-source: userset; mso-width-alt: 11008" width=301><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 43pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=57 height=20>List 1</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 33pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=44></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 34pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=45></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 226pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=301></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Amount</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">Name</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">Match</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>223</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">aa</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc">aa</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> =INDEX($G$4:$G$10,MATCH(A4,$F$4:$F$10,0))</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>500</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">bb</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc">bb</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> =INDEX($G$4:$G$10,MATCH(A5,$F$4:$F$10,0))</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>1334</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">aa</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc" align=middle>#N/A</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> =INDEX($G$4:$G$10,MATCH(A6,$F$4:$F$10,0))</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>556</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">cc</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc" align=middle>#N/A</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> =INDEX($G$4:$G$10,MATCH(A7,$F$4:$F$10,0))</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>500</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">ee</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc">bb</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> =INDEX($G$4:$G$10,MATCH(A8,$F$4:$F$10,0))</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>344</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">aa</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc" align=middle>#N/A</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> =INDEX($G$4:$G$10,MATCH(A9,$F$4:$F$10,0))</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>500</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">bb</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc">bb</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> =INDEX($G$4:$G$10,MATCH(A10,$F$4:$F$10,0))</TD></TR></TBODY></TABLE>


<TABLE style="WIDTH: 76pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=101 border=0><COLGROUP><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width=57><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1609" width=44><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 43pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=57 height=20>List 2</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 33pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=44></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Amount</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">Name</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>434</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">ff</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>334</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">dd</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>500</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">bb</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>5454</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">cc</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>500</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">ee</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>223</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">aa</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>250</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">bb</TD></TR></TBODY></TABLE>

In column Match of List1 value "bb" is three times. Here the first match for 500 is shown in all later matches. This is how Match function works in excel. But how do I see different matches for 500 (bb, ee, bb)?

 

[Andrew Poulsom]

Try:

=INDEX($G$4:$G$10,MATCH(1,INDEX(($F$4:$F$10=A4)*($G$4:$G$10=B4),),0))

 

[animas]

Terrific. Can you pls briefly explain the Match(.. portion?

 

[Andrew Poulsom]

This:

($F$4:$F$10=A4)*($G$4:$G$10=B4)

Returns 1 if both conditions are true, otherwise zero. MATCH returns the position of the first occurrence of 1. I wrapped the condition in an INDEX function to avoid having to press Ctrl+Shift+Enter (array formula).

 

[animas]

Thanks.

 

[animas]

I was checking it with different values.

<table border="0" cellpadding="0" cellspacing="0" width="285"><col style="width: 51pt;" width="68"> <col style="width: 47pt;" width="63"> <col style="width: 47pt;" width="62"> <col style="width: 69pt;" width="92"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl136" style="height: 15pt; width: 51pt;" height="20" width="68">List 1</td> <td style="width: 47pt;" width="63">
</td> <td style="width: 47pt;" width="62">
</td> <td style="width: 69pt;" width="92">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl139" style="height: 15pt;" height="20">Amount</td> <td class="xl139" style="border-left: medium none;">Name</td> <td class="xl139" style="border-left: medium none;">Match</td> <td class="xl139" style="border-left: medium none;">Super MATCH</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl137" style="height: 15pt; border-top: medium none;" align="center" height="20">223
</td> <td class="xl137" style="border-top: medium none; border-left: medium none;" align="center">aa</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">aa</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">aa</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl137" style="height: 15pt; border-top: medium none;" align="center" height="20">500
</td> <td class="xl137" style="border-top: medium none; border-left: medium none;" align="center">bb</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">xx</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl137" style="height: 15pt; border-top: medium none;" align="center" height="20">1334
</td> <td class="xl137" style="border-top: medium none; border-left: medium none;" align="center">aa</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl137" style="height: 15pt; border-top: medium none;" align="center" height="20">556</td> <td class="xl137" style="border-top: medium none; border-left: medium none;" align="center"> cc</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl137" style="height: 15pt; border-top: medium none;" align="center" height="20">500
</td> <td class="xl137" style="border-top: medium none; border-left: medium none;" align="center">ee</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">xx</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl137" style="height: 15pt; border-top: medium none;" align="center" height="20">344
</td> <td class="xl137" style="border-top: medium none; border-left: medium none;" align="center">aa</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl137" style="height: 15pt; border-top: medium none;" align="center" height="20">500</td> <td class="xl137" style="border-top: medium none; border-left: medium none;" align="center"> bb</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">xx</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> </tbody></table>


<table border="0" cellpadding="0" cellspacing="0" width="127"><col style="width: 55pt;" width="73"> <col style="width: 41pt;" width="54"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl137" style="height: 15pt; width: 55pt;" height="20" width="73">List 2</td> <td style="width: 41pt;" width="54">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl140" style="height: 15pt;" height="20">Amount</td> <td class="xl140" style="border-left: medium none;">Name</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl139" style="height: 15pt; border-top: medium none;" align="center" height="20">434
</td> <td class="xl139" style="border-top: medium none; border-left: medium none;" align="center">ff</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl139" style="height: 15pt; border-top: medium none;" align="center" height="20">334
</td> <td class="xl139" style="border-top: medium none; border-left: medium none;" align="center">dd</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl139" style="height: 15pt; border-top: medium none;" align="center" height="20">500
</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center">xx</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl139" style="height: 15pt; border-top: medium none;" align="center" height="20">5454
</td> <td class="xl139" style="border-top: medium none; border-left: medium none;" align="center">cc</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl139" style="height: 15pt; border-top: medium none;" align="center" height="20">500</td> <td class="xl138" style="border-top: medium none; border-left: medium none;" align="center"> yy</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl139" style="height: 15pt; border-top: medium none;" align="center" height="20">223</td> <td class="xl139" style="border-top: medium none; border-left: medium none;" align="center"> aa</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl139" style="height: 15pt; border-top: medium none;" align="center" height="20">250
</td> <td class="xl139" style="border-top: medium none; border-left: medium none;" align="center">mm</td> </tr> </tbody></table>

Here Super Match column not showing values for 500(yy).

 

[Andrew Poulsom]

You don't have 500 yy in your List 1.