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.