I am looking for a recommendation on a formula or other option to best complete the following task.
I have two data sheets that have different data but have a common identifier between the two, so my ask is to take the common identifier and to essentially merge the data from both sheets onto one sheet. What I have done initially was used VLOOKUP on one sheet and its searching the other data sheet for the common identifier and then bringing along the accompanying data. Here is a copy of my current formula =VLOOKUP($A$35,Case_Form!$A2:$C$44,2,FALSE). My struggle is I would like to be able to bring the whole row of data over rather than my current process where I am changing what cell to bring over in my formula ie 2-3-4-5.... I am sure there is a much better way to accomplish this task. Thanks in advance.
I have two data sheets that have different data but have a common identifier between the two, so my ask is to take the common identifier and to essentially merge the data from both sheets onto one sheet. What I have done initially was used VLOOKUP on one sheet and its searching the other data sheet for the common identifier and then bringing along the accompanying data. Here is a copy of my current formula =VLOOKUP($A$35,Case_Form!$A2:$C$44,2,FALSE). My struggle is I would like to be able to bring the whole row of data over rather than my current process where I am changing what cell to bring over in my formula ie 2-3-4-5.... I am sure there is a much better way to accomplish this task. Thanks in advance.