# Excel - COLUMN Function Problem - Expert Solution

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

i am trying to compare column a to b in a spreadsheet
Solved by T. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 08/05/2018 - 02:56
Hello, I understand that you want to compare 2 columns. Can you elaborate on your request please?
User 08/05/2018 - 02:56
I have a list of numbers in column a and need to compare them to a similar list in column b to see which ones match
Excelchat Expert 08/05/2018 - 02:57
I see. Are you able to share that list so I can provide an accurate formula?
User 08/05/2018 - 02:57
yes
Excelchat Expert 08/05/2018 - 02:57
If not, we can just create a dummy list.
Excelchat Expert 08/05/2018 - 02:57
Okay, please upload your file or you can just copy the list using the document preview to the right.
User 08/05/2018 - 02:58
finished
Excelchat Expert 08/05/2018 - 02:58
Okay, so do you like to compare A to B or would it be B to A?
User 08/05/2018 - 02:58
a to b
Excelchat Expert 08/05/2018 - 02:59
Alright, before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question.
Excelchat Expert 08/05/2018 - 02:59
In column C I'll be writing a formula that checks if the value in column A is i column B.
Excelchat Expert 08/05/2018 - 02:59
So here, you can see the result has a mix of numbers and #N/A
Excelchat Expert 08/05/2018 - 03:00
An #N/A means that the value in column A is NOT in column B.
Excelchat Expert 08/05/2018 - 03:00
While a number means that the value in column A was found in that row in column B.
Excelchat Expert 08/05/2018 - 03:00
For instance, D000054226 (A1)
Excelchat Expert 08/05/2018 - 03:00
The formula results in 116.
Excelchat Expert 08/05/2018 - 03:00
This means that D000054226 was found in row 116 in column B.
User 08/05/2018 - 03:00
ok but I did not see the formula used
Excelchat Expert 08/05/2018 - 03:01
While D000054705 results to #N/A
Excelchat Expert 08/05/2018 - 03:01
Which means it is not in column B.
Excelchat Expert 08/05/2018 - 03:01
=match(A1,B:B,0)
Excelchat Expert 08/05/2018 - 03:01
To see the formula you can just click the cell.
Excelchat Expert 08/05/2018 - 03:01
Click Cell C1 and you will see the formula.
User 08/05/2018 - 03:01
ok
Excelchat Expert 08/05/2018 - 03:02
Got it?
User 08/05/2018 - 03:02
yes
Excelchat Expert 08/05/2018 - 03:02
Would there be anything else that I can help you with regards to the original question?
User 08/05/2018 - 03:02
that's all thanks
Excelchat Expert 08/05/2018 - 03:03
Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.
Excelchat Expert 08/05/2018 - 03:03
I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.
Excelchat Expert 08/05/2018 - 03:03
Thank you for contacting Got It Pro. Have an awesome day!

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.