I have the following lookup formula. It works fine except when the lookup
values are the same, it produces similar results when it should actually
produce another value.

{=INDEX(DATA!$AA$2:$AA$1018,MATCH(1,(DATA!$G$2:$G$ 1018=B29)*(DATA!$R$2:$R$1018=C29),0))}

A B C
1 abc def 123
2 abc def 456

In my data, it sometimes create the above example and thus, the formula
produce the result 123 twice, when it should be 123, followed by 456.

Is there anyone who can help me on this? Thanks in advance