Forum Discussion
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, Main(1st tab) will have 452738(unique ID) on row 3. and on (supplier) tab2
will have 452738(unique ID) on row 583.
What i want to do is merge them together and put it to one tab instead. How do i go about using excel function to get this done. i tried vlookup but always get an error.
=VLOOKUP(F4,'Supplier''s input'!H4:H65536,8,1) F4 would mean the unique ID is in F4 of Main(1st Tab)and column H4:H65536 on supplier(tab 2).
- 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.
First of all, try absolute address
=VLOOKUP($F4,'Supplier''s input'!$H$4:$H$65536,8,0)
