Fill the Blank Cell

[sambit]

Sir,
Please help to resolve the below issue.
Fill the blank cell, Doc No is the same if the corresponds invoice is the same. However, in some cases Doc No is different for the same Invoice No.

Example file attached for your reference.

 

[John Jairo V]

Hi, @sambit!

You could try this formulas:

[I6] : =IF(C6,C6,INDEX(C$6:C$32,MATCH(J6,D$6:D$32/(C$6:C$32<>""),)))
[J6] : =D6

Blessings!

 

[sambit]

John Sir,
Thank you very much.

it's working fine.