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