VLOOKUP Formula

[Rajendar]

Dear Friends

Help me in V lookup formula. When i apply the formula same data is repeating multiple times

Herewith attached excel sheet

Thanks & Regards
Aelmareddy

 

[bosco_yip]

In D2, copied down :

=IF(A2="","",INDEX(DATA!$B$2:$B$100,AGGREGATE(15,6,ROW(DATA!$A$2:$A$100)-ROW(DATA!$A$1)/(DATA!$A$2:$A$100=A2),IF(COUNTIF(A$2:A2,A2)>COUNTIF(DATA!A$2:A$100,A2),1,COUNTIF(A$2:A2,A2)))))

Regards
Bosco

 

[Rajendar]

Dear Bosco

Thanks !

Please see the attachment i added small comments on that in one condition same PO number is repeating and i also i added PO Qty when work order number and PO number match the PO QTY to be reflected in D2: D15

Thanks & Regards
Aelmareddy

 

[bosco_yip]

Dear Bosco

Thanks !

Please see the attachment i added small comments on that in one condition same PO number is repeating and i also i added PO Qty when work order number and PO number match the PO QTY to be reflected in D2: D15

Thanks & Regards
Aelmareddy

Please see the revised file.

Regards
Bosco

 

[Rajendar]

Hi,

Bosco,

Thanks. 100% its working