Forum Discussion

Copper Contributor

Jan 12, 2018

Solved

function to merge multiple tab

Hi guys, I need a little help on excel functions. I have a worksheet with multiple tabs. on each tab it consists of a unique id with all the information for that unique ID. say for example, M...

Excel Desktop

Formulas & Functions

Willy Lau
Jan 16, 2018
I see. You want to merge all fields in tab2 to tab1, and F column in tab1 is used to match H column in tab2.

Since there are columns in front of H column in tab2, VLOOKUP formula does not fit your need.

Please try INDEX formula and MATCH formula.

ana ayesh

Copper Contributor

Jan 15, 2018

it sin column H.

Willy Lau

Iron Contributor

Jan 16, 2018

I see. You want to merge all fields in tab2 to tab1, and F column in tab1 is used to match H column in tab2.

Since there are columns in front of H column in tab2, VLOOKUP formula does not fit your need.

Please try INDEX formula and MATCH formula.

ana ayesh
Copper Contributor
Jan 16, 2018
issue solved. Thanks alot for the command to execute it.

It is =IF(B4="",L3,B4) on tab 1 new column

=INDEX('Supplier''s input'!$A$4:$XX$65535, MATCH($F5,'Supplier''s input'!$H$4:$H$65535, 0), 10) XX should be the last column in tab2.