Forum Discussion
Match Cells on Sheet 1 & 2 and return value from a cell on Sheet 2 to a new cell on Sheet 1
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.- This work great is there a way to bring over the hyperlink as well
That did it! I can't thank you enough!!!
Katie, you are welcome
SergeiBaklan I'm attempting the same thing but cannot get the formula to work. If sheet 1 column J to match sheet 2 column G then return the value of column E from sheet 2 onto sheet 1 column L.
At what part of the formula does it look at column E from sheet 2 and add to sheet 1?
Thank you,
