Reference formula to pick based on criterea

[Nandakumar]

Hi,

Can you please help me one formula for one column to arrive at reference to particular cell .I attached worksheet and provided how formula should be.

Thanks in Advance

 

[bosco_yip]

F2, copy down :

=LOOKUP(2,1/(B$2:B2=B$2),C$2:C2)&LOOKUP(2,1/(B$2:B2=B$2),C$3:C3)&E2

Regards

 

[Nandakumar]

Perfect.

It works well.

Thank you so much.

F2, copy down :

=LOOKUP(2,1/(B$2:B2=B$2),C$2:C2)&LOOKUP(2,1/(B$2:B2=B$2),C$3:C3)&E2

Regards

 

[Nandakumar]

Hi,

I need a small help on the formula.Only for particular company formula should add "_".
Attached Excel sheet for your kind reference.

Thanks in Advance

 

[bosco_yip]

Hi,

I need a small help on the formula.Only for particular company formula should add "_".
Attached Excel sheet for your kind reference.

Thanks in Advance

Try this replacement,

In F2, copy down :

=LOOKUP(2,1/(B$2:B2=B$2),C$2:C2)&LOOKUP(2,1/(B$2:B2=B$2),C$3:C3)&IF(LOOKUP(2,1/(B$2:B2=B$2),C$2:C2)="B","_"&LOOKUP(2,1/(B$2:B2=B$2),C$3:C3),"")&E2

Regards

 

[Nandakumar]

Thank you so much...

Try this replacement,

In F2, copy down :

=LOOKUP(2,1/(B$2:B2=B$2),C$2:C2)&LOOKUP(2,1/(B$2:B2=B$2),C$3:C3)&IF(LOOKUP(2,1/(B$2:B2=B$2),C$2:C2)="B","_"&LOOKUP(2,1/(B$2:B2=B$2),C$3:C3),"")&E2

Regards