Vlookup or any from two column

[Addiaz]

Good morning all,

Can anybody help me ? (am sure more excel expert here ^_^), in my case i have one account code for each cost center, and i would to combine them in one sheet (refer to my attached) can i use vlookup or any formula for vlookup them ?

Thanks in advance

Addize

[NeedForExcel]

Can the Code-Lao be duplicate?

Put this in Cell D5 and Drag down and Across

=IFERROR(INDEX(Data!$D$2:$K$235,MATCH($A5+0,Data!$A$2:$A$235,0),MATCH(Summery!D$4,Data!$D$1:$K$1,0)),"-")

Or

=IFERROR(VLOOKUP($A5+0,Data!$A$1:$K$235,MATCH(D$4,Data!$A$1:$K$1,0),0),"-")

[FlameRetired]

Another way. In D6 fill down and across.

Please Login or Register  to view this content.

[Addiaz]

Dear All,

Thanks all of your guy make me submitted my report on time, two formula above am not really understand how is work lol, i have tried formula from Dave. is work

Thankss you

Addiaz

[FlameRetired]

You're welcome, Addiaz. Glad to hear about the report, and thanks for the rep.