Excel - IF Function Problem - Expert Solution

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.

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.