Period match

[Thomas Kuriakose]

Respected Sirs,

We have a workbook with Invoice numbers (A2:A618) and the period (B2:B618) of the invoices. The same invoice can be active in two periods.

We need to match the invoice with the period and enter the duplicate invoices as per period.

Kindly find attached the file with details. The results of a few are entered in column D.

Thank you very much for your guidance and support always,

with regards,
thomas

 

[GraH - Guido]

perhaps [D2]=[@Month]&IFERROR("-"&VLOOKUP([@[Invoice No]],$A3:$C$619,3,0),"")?

EDIT:
or =IFERROR(TEXT(VLOOKUP([@[Invoice No]],$A3:$B$619;2;0),"mmm")&"-","")&TEXT([@Period],"mmm") to have the periods in a logic order
or=IFERROR(TEXT(VLOOKUP([@[Invoice No]],$A3:$B$619;2;0),"[$-EN-UK]mmm")&"-","")&TEXT([@Period],"[$-EN-UK]mmm") to always force the month names in English
or =IF(COUNTIF($A$2:$A2,[@[Invoice No]])=1,IFERROR(TEXT(VLOOKUP([@[Invoice No]],$A3:$B$619;2;0),"[$-EN-UK]mmm")&"-","")&TEXT([@Period],"[$-EN-UK]mmm"),"Duplicate") to only have the double month references for each invoice once.

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for your guidance and support on this query.

I applied the EDIT and get the months repeated in cells. The result required is as in Column D.

Kindly guide where I am going wrong.

Thank you very much for your support,

with regards,
thomas

 

[GraH - Guido]

=IFERROR(TEXT(VLOOKUP([@[Invoice No]],$A3:$B$619;2;0),"mmm")&"-","")&TEXT([@Period],"mmm") , you had A2 referenced.

But I now see you want the same period referenced for the duplicated values. #HoldOnAMinute

EDIT: see attached if that is suitable, Thomas.

 

[Thomas Kuriakose]

Respected Sir,

This is perfect. Thank you so very much for this solution,

Much appreciated,

with regards,
thomas