Formula Required

[Harish Venkataraju]

Need little help in following issue which I am coming across at work.

I have 2 coulmn's data, in column A = Sale orders, Column B = Line id, we need to drag unique line id for all the similar Sale orders in Column B, looking at Column "A" information.

Eg : Column A2 = 32992947, Column B2 = 3299294732992947+1+1, B3 = N/A we need this to be filled with upper B2 data.

If there is any Order which is without Line id it can be as "N/A".

Is there any way we could fill the cells based on Sale order in column "A"

I am attaching a file with the sample data, let me know if need to put this case in group chat.

Regards,
Harish

 

[Asheesh]

Hi Harish -

Welcome onboard...

Use the formula in Cell C2 and then drag - VLOOKUP(A2,$A$2:$B$795,2,0)

 

[Deepak]

Check this..

C2 =IF(A2=A1,C1,B2)

Note : I doesn't think that this is an excel challenge.

 

[Deepak]

Oh..Yes !
I must go with Asheesh Solution.