**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.*