vlookup match formula

[Rajendar]

Dear Friends,

Please help me to complete the formula. I need Vlookup to match the data from data sheet A:B

Herewith attached sample sheet

Thanks & Regards
Aelma reddy

 

[Khalid NGO]

Hi,

Please try this:

=IFERROR(INDEX(DATA!$C$2:$C$14,MATCH(FORMULA!A2&FORMULA!B2,INDEX(DATA!$A$2:$A$14&DATA!$B$2:$B$14,),0)),"")

Regards,

 

[Rajendar]

Hi,

Khalid

Thanks

I copied this formulas and i was pasted in the cell. in one condition the same value is repeating. Please see the attachment

 

[bosco_yip]

Then,

try.......

=IFERROR(INDEX(DATA!$C$2:$C$13,AGGREGATE(15,6,ROW(DATA!$C$2:$C$13)-ROW(DATA!$C$1)/(A2=DATA!$A$2:$A$13)/(B2=DATA!$B$2:$B$13),COUNTIFS(A$2:A2,A2,B$2:B2,B2))),"")

Regards
Bosco

 

[Rajendar]

Hi

Bosco

Thanks