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

Hi I have tried to use absolute and im still getting an error. #ref.

ana ayesh

Copper Contributor

Jan 15, 2018

if i understand.. it should be F4 and table array H1 : h65536 ?

Willy Lau
Iron Contributor
Jan 15, 2018
May I know which column in tab2 contains the value of F4 from tab1?
- 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.