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 ...
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,MATCH(J1, Sheet2!G:G, 0) returns first found position in Sheet2!G:G where the value is equal to value of J1, or error if nothing was found.
INDEX(Sheet2!E:E, <above position>) returns the value of the cell in column Sheet2!E:E which is on that position.
All together
=IFERROR( INDEX ( Sheet2!E:E, MATCH( J1, Sheet2!G:G, 0) ), "nothing found")- Hi HMills8475 I am attempting almost similar but cannot get it to work. I hope you can notice this and help.
If the value in column B is in Sheet 1, column I, return x. But if the value in column B is in Sheet 2, column c, return y.
