Question description:
This user has given permission to use the problem statement for this
blog.
I am comparing two sheets - Sheet 1 and Sheet 2. If the value in column E in Sheet 1 matches the value in column D in sheet 2 I want to return a value from the same row in column C in Sheet 2.
Solved by O. S. in 30 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
03/09/2018 - 12:06
Welcome to ExcelChat!
User
03/09/2018 - 12:06
I am comparing two sheets - Sheet 1 and Sheet 2. If the value in column E in Sheet 1 matches the value in column D in sheet 2 I want to return a value from the same row in column C in Sheet 2.
Excelchat Expert
03/09/2018 - 12:07
Will you provide the data where you need to have the solution?
User
03/09/2018 - 12:08
one moment
User
03/09/2018 - 12:14
I want to return the value to column F in Sheet 1
[Uploaded an Excel file]
Excelchat Expert
03/09/2018 - 12:16
So if E from Sheet1 = D from Sheet 2, on Sheet 2 column C you want to have a value
Excelchat Expert
03/09/2018 - 12:16
But which value do you want to have there?
User
03/09/2018 - 12:17
If E in sheet 1 matches D in Sheet 2, return the value from column C in Sheet 2 to column F in Sheet 1
Excelchat Expert
03/09/2018 - 12:17
Oh, great, I got your task
Excelchat Expert
03/09/2018 - 12:17
Will send you the file back soon
User
03/09/2018 - 12:17
note that the matching data will not always be on the same row in corresponding sheets
Excelchat Expert
03/09/2018 - 12:18
In column F in Sheet1 you have Created Month
Excelchat Expert
03/09/2018 - 12:19
Do you want the formula to be below it, in F2?
Excelchat Expert
03/09/2018 - 12:23
When you see the pop up, please, extend the session. Thank you.
User
03/09/2018 - 12:24
F2
Excelchat Expert
03/09/2018 - 12:24
Please, extend the session by pressing a button
Excelchat Expert
03/09/2018 - 12:24
Otherwise you won't be able to chat
Excelchat Expert
03/09/2018 - 12:32
I have created the Chat Sheet
Excelchat Expert
03/09/2018 - 12:32
Please write you messages there
Excelchat Expert
03/09/2018 - 12:33
Look, I have created the solution in F2
Excelchat Expert
03/09/2018 - 12:33
It works as you described
Excelchat Expert
03/09/2018 - 12:34
If E from Sheet1 is found in column D on Sheet2, then it returns C from Sheet2, otherwise blank
Excelchat Expert
03/09/2018 - 12:34
The formula is
Excelchat Expert
03/09/2018 - 12:34
=iferror(if(match(E2,Sheet2!$D:$D,0)<>"",index(Sheet2!$C:$C,match(E2,Sheet2!$D:$D,0))),"")
Excelchat Expert
03/09/2018 - 12:35
Here is the result in the Excel sheet that you sent me
[Uploaded an Excel file]
Excelchat Expert
03/09/2018 - 12:36
Wish you a great day!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
