Forum Discussion
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...
- 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)
Hi I have tried to use absolute and im still getting an error. #ref.
if i understand.. it should be F4 and table array H1 : h65536 ?
May I know which column in tab2 contains the value of F4 from tab1?
I am sorry. I gave the wrong answer. Your selected table array should be having the first column in which you are searching the unique ID. Also, the table array should include the column that you want.
