Forum Discussion

ana ayesh's avatar
ana ayesh
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's avatar
    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.
Willy Lau's avatar
Willy Lau
Iron Contributor
Jan 12, 2018

First of all, try absolute address

=VLOOKUP($F4,'Supplier''s input'!$H$4:$H$65536,8,0)
ana ayesh's avatar
ana ayesh
Copper Contributor
Jan 15, 2018

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

Resources