# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I'm trying to figure out how to have a value found in column c placed into column d if the value in column a equals that found in column b. Does that make sense?
Solved by I. H. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 14/09/2018 - 01:44
Welcome, Thanks for choosing Got It Pro-Excel. I can help you with that problem.
Excelchat Expert 14/09/2018 - 01:44
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert 14/09/2018 - 01:44
Do you have sample data which we can use to illustrate how to solve this problem?
User 14/09/2018 - 01:44
thanks. sounds good
User 14/09/2018 - 01:46
I just put some in the document preview- can you see it?
User 14/09/2018 - 01:46
I will use that as an example
Excelchat Expert 14/09/2018 - 01:46
Okay.
User 14/09/2018 - 01:48
So, I want to know how to have the values in column D placed in column A if the value in column E is found in column B
User 14/09/2018 - 01:49
For example, the value in A2 should be '6' based on this data. Does that make sense?
User 14/09/2018 - 01:50
I'm looking for a formula I can use to make those values associated with the list in column E automatically appear in Column A based on the values in column b
User 14/09/2018 - 01:51
Does my question make sense?
Excelchat Expert 14/09/2018 - 01:51
I get you
Excelchat Expert 14/09/2018 - 01:51
Will you mind if you add another example to make this clearer?
Excelchat Expert 14/09/2018 - 01:53
What value should we have in cell A3?
Excelchat Expert 14/09/2018 - 01:53
7
Excelchat Expert 14/09/2018 - 01:53
?
User 14/09/2018 - 01:53
7
User 14/09/2018 - 01:54
correct
User 14/09/2018 - 01:54
A6 should be '1'
Excelchat Expert 14/09/2018 - 01:54
Okay.
User 14/09/2018 - 01:54
A4 should be empty (no value)
Excelchat Expert 14/09/2018 - 01:56
Based on what you’ve shared, you need a LOOKUP function which will find column B values in column E and then return their corresponding values in column D.
Excelchat Expert 14/09/2018 - 01:56
Do you believe that will address your problem?
User 14/09/2018 - 01:56
Yes. that sounds promising
Excelchat Expert 14/09/2018 - 01:57
Allow me formulate a formula that will solve this problem.
User 14/09/2018 - 01:57
Thank you!
Excelchat Expert 14/09/2018 - 01:57
Will be updating you in a couple of minutes.
User 14/09/2018 - 02:06
You still there?
Excelchat Expert 14/09/2018 - 02:06
Yeah, almost done...
User 14/09/2018 - 02:07
cool. no rush.
Excelchat Expert 14/09/2018 - 02:09
You said if it is not found, zero should be returned?
User 14/09/2018 - 02:09
Or just leave it blank, send me an error, something
Excelchat Expert 14/09/2018 - 02:10
Okay. Let's leave it blank.
User 14/09/2018 - 02:10
sounds good
Excelchat Expert 14/09/2018 - 02:11
Thank you once again for your patience.
Excelchat Expert 14/09/2018 - 02:11
The formula which works for the range provided is:
Excelchat Expert 14/09/2018 - 02:11
=IFERROR(INDEX(\$D\$1:\$D\$10,MATCH("*"&B1&"*",\$E\$1:\$E\$10,0)),"")
User 14/09/2018 - 02:12
That looks awesome. Thank you!
Excelchat Expert 14/09/2018 - 02:12
Welcome.
Excelchat Expert 14/09/2018 - 02:12
Do you have any other questions about this problem and the solution?
User 14/09/2018 - 02:12
For the actual data set I'll be working, I can just change the column values and we should be good, right?
Excelchat Expert 14/09/2018 - 02:13
Yeah
User 14/09/2018 - 02:13
This is a fantastic service. I really appreciate all of your help and will definitely be back
Excelchat Expert 14/09/2018 - 02:13
It was my pleasure helping you solve this problem. Any time you have a problem with Excel do not hesitate to come back for help.
User 14/09/2018 - 02:14
Thank you. We are all set
Excelchat Expert 14/09/2018 - 02:18
Please remember to rate us at the end of the chat for better and quality services. Thank you!

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.

## Click here to get your free Excelchat help session

Trusted by people who work at