Forum Discussion
Match Cells on Sheet 1 & 2 and return value from a cell on Sheet 2 to a new cell on Sheet 1
Sheet 1, Column B lists names. Same names are listed multiple times. Sheet 2, Column A lists one name and Sheet 2, Column B lists phone # for corresponding name.
If the name in Sheet 1, Column B matches the name in Sheet 2, Column A then the phone # in Sheet 2, Column B needs to be added to Sheet 1, Column A.
I've attached a test workbook to help demonstrate.
Can I do this with a formula? Or do I need a macro? I've been trying different formulas and can't seem to get it to work.
I believe I have a similar problem.
Sheet 1, Column B lists names. Same names are listed multiple times. Sheet 2, Column A lists one name and Sheet 2, Column B lists data points for corresponding name.
If the name in Sheet 1, Column B matches the name in Sheet 2, Column A and the date in Sheet 1, Column C matches the date in Sheet 2, Column C then the data in Sheet 2, Column B needs to be added to Sheet 1, Column A.
Each listing of a name comes from a different month in which data was pulled. The month is listed in Sheet 1, Column C.
That being said, each data point is different and needs to match up with the name and month when added to Sheet 1, Column A.
Hi Katie,
That could be like
=IFERROR(INDEX(Sheet2!$B$2:$B$10,MATCH(Sheet1!$B2,Sheet2!$A$2:$A$10,0)),"")
and attached
Please could you help.
I would like to compare data on sheet 1 (A3:A1065) & 2(B2:B279) and if they match to return a specific value from sheet 2; Column D onto sheet 1, Column C - along side the matching information - if there is no match in the array to return NO as a value in sheet 1, Column C.
I hope thats understandable and you can assist
Not sure I understood how the data is structured. As variant
=XLOOKUP($A$3:$A1065,Sheet2!$B$2:$B$279,Sheet2!$C$2:$C$279, "No" )
Hello SergeiBaklan
I have a query regarding the process you explained in your previous communication. Is there an option to apply the same procedure to two distinct sheets?
If I am understanding correctly, the method you mentioned pertains to separate tabs within a single sheet. Could you kindly confirm if my understanding is accurate?
My requirement involves extracting data from a sheet located in a different folder altogether. Your guidance on this matter would be greatly appreciated.
Thank you for your time and assistance.
I have an Excel file with two sheets. All data stored in sheet 2 in row and column index.
In sheet 1 I need some data just like rows and columns but not all rows and columns.
