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 ...
Hi Katie,
That could be like
=IFERROR(INDEX(Sheet2!$B$2:$B$10,MATCH(Sheet1!$B2,Sheet2!$A$2:$A$10,0)),"")
and attached
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.