Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.