Question description:
This user has given permission to use the problem statement for this
blog.
I have a sheet with 3 columns. First column is a code for records in column B (has 563 records). What I need is a formula to show me if what is in column C (has 4400 records) is in column B and if it is to take the code for that record.
Example:
Column A(code corresponding to column B): 12, 14, 15, 19
Column B(names): asd, adf, ade, aqw
Column C(names): akd, adf, ade, anb, wgs
I need something that would say, if record in column C (for example adf) is matching record in column B (adf) return the code from column A (the code corresponding to that record in column B),if not return blank.
Solved by C. J. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
24/05/2018 - 12:31
Hello, welcome to got it pro
User
24/05/2018 - 12:31
hello
Excelchat Expert
24/05/2018 - 12:32
I understand that you want codes for the names in column C.
User
24/05/2018 - 12:32
yes
Excelchat Expert
24/05/2018 - 12:32
Right?
Excelchat Expert
24/05/2018 - 12:32
Okay.
Excelchat Expert
24/05/2018 - 12:32
I would love that if you can show me a few sample data in the preview window.
User
24/05/2018 - 12:33
I've managed to make the match between B and C with this =IFERROR(IF(VLOOKUP(B2,$A:$A,1,FALSE)=B2,"x"),"") but not sure how to include also to return code from A
Excelchat Expert
24/05/2018 - 12:33
VLOOKUP won't work here in this case.
Excelchat Expert
24/05/2018 - 12:34
VLOOKUP can only return value from the right hand sides column. SO, we need to use a different formula.
Excelchat Expert
24/05/2018 - 12:34
Thank you, I can see the data.
Excelchat Expert
24/05/2018 - 12:35
Please use this formula in column D2. =IFERROR(INDEX(A:A,MATCH(C2,B:B,0)),"")
User
24/05/2018 - 12:35
and for example on line 3, I need to see for as code 1 because it is matching it
Excelchat Expert
24/05/2018 - 12:36
Hmm, the formula I wrote is showing that result.
Excelchat Expert
24/05/2018 - 12:36
Please check it and let me know.
User
24/05/2018 - 12:37
perfect it is working
User
24/05/2018 - 12:37
encountered the formula you have given me but didn't thought to use it
User
24/05/2018 - 12:37
thank you very much
User
24/05/2018 - 12:37
you're the best :)
Excelchat Expert
24/05/2018 - 12:37
I'm glad to be able to help.
Excelchat Expert
24/05/2018 - 12:38
Please rate me 5 star if you think I have earned it.
Excelchat Expert
24/05/2018 - 12:38
:)
User
24/05/2018 - 12:38
I will
Excelchat Expert
24/05/2018 - 12:38
You will be asked to rate me if you opt to end session now, otherwise the session will end in 12 minutes.
User
24/05/2018 - 12:38
I will end it
User
24/05/2018 - 12:38
thank you
Excelchat Expert
24/05/2018 - 12:38
Thank you. Have a great day.
User
24/05/2018 - 12:38
you too
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.