Multiple value look

[ssj011]

Hi,


I want the container number (Column E) to be added next to the PO number (Column F)
container number always come in between of the range Like in 1st case
Booking Number : 967439399
Container Number : MRKU4574021
In above case i want formula which will show container number in column E till the row in column H wheren "Z_RATE_TIME_END_DATE" is updated .

There will be cases where multiple container for same PO number

Regards
Sachin

 

[bosco_yip]

Try..........................

In E2, copied down :

=IF(F2="","",IF(OR(F2<>F1,H1="Z_RATE_TIME_END_DATE"),INDEX(D2:D$156,MATCH(1,INDEX(0+(D2:D$156<>""),0),0)),E1))

Regards
Bosco

 

[ssj011]

Good Day Bosco,

Thanks a lot for your quick assistance .

Have a nice day ahead

Regards
Sachin