# Excel - COLUMN Function Problem - Expert Solution

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

Using the data in Column A I want to match the data in Column B showing me what data is missing or unmatched. How can I do this?
Solved by V. L. in 59 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/02/2018 - 01:58
Hello, Welcome to Got It Pro
Excelchat Expert 02/02/2018 - 01:58
Excelchat Expert 02/02/2018 - 02:01
Are you there?
User 02/02/2018 - 02:01
yes
Excelchat Expert 02/02/2018 - 02:02
Okay great. So you want to match A and B columns to tell which are matching and which are not?
User 02/02/2018 - 02:03
correct
Excelchat Expert 02/02/2018 - 02:03
and it should display "matched or not matched"?
User 02/02/2018 - 02:04
yes
User 02/02/2018 - 02:04
matched
Excelchat Expert 02/02/2018 - 02:04
Okay. Please give me two minutes
User 02/02/2018 - 02:05
can you get them side by side
User 02/02/2018 - 02:06
234567 is matched
User 02/02/2018 - 02:08
123456 is not matched
Excelchat Expert 02/02/2018 - 02:08
By side by side you mean?
User 02/02/2018 - 02:08
yes
User 02/02/2018 - 02:09
cellb1 should be blank and the others side by side
User 02/02/2018 - 02:09
Cell B1
Excelchat Expert 02/02/2018 - 02:10
cell B1 has the number 987654
User 02/02/2018 - 02:11
It does not match A1
User 02/02/2018 - 02:11
I would like column B unscrambled to match column A side by side
User 02/02/2018 - 02:13
Automatically sort the data in column B to match Column A
Excelchat Expert 02/02/2018 - 02:14
we have to manually sort the data first then
Excelchat Expert 02/02/2018 - 02:16
User 02/02/2018 - 02:17
some match, sme dont
Excelchat Expert 02/02/2018 - 02:17
so you want to display them so they match with c olumn A ?
User 02/02/2018 - 02:18
yes
Excelchat Expert 02/02/2018 - 02:19
Okay
User 02/02/2018 - 02:22
are u with me?
Excelchat Expert 02/02/2018 - 02:23
Yes I am here
Excelchat Expert 02/02/2018 - 02:23
I am working on your file.
User 02/02/2018 - 02:23
ty
Excelchat Expert 02/02/2018 - 02:26
No problem. Just give me few minutes
Excelchat Expert 02/02/2018 - 02:33
Its is very difficult to do with formula, Its a VBA query
User 02/02/2018 - 02:33
VBA query ?
Excelchat Expert 02/02/2018 - 02:33
like by coding.
User 02/02/2018 - 02:34
can we talk by phone?
Excelchat Expert 02/02/2018 - 02:35
No I am sorry, We dont have that facility
Excelchat Expert 02/02/2018 - 02:43
User 02/02/2018 - 02:43
you did it! how?
Excelchat Expert 02/02/2018 - 02:44
by sorting the columns in ascending order
User 02/02/2018 - 02:45
show me?
User 02/02/2018 - 02:51
please show me...I have to go
Excelchat Expert 02/02/2018 - 02:51
I have used VLOOKUP to match and sort your data
Excelchat Expert 02/02/2018 - 02:51
=VLOOKUP(A1,\$B\$1:\$C\$8,1,FALSE)
Excelchat Expert 02/02/2018 - 02:51
Excelchat Expert 02/02/2018 - 02:53
It is showing the matching columns for A
User 02/02/2018 - 02:54
Thank you!

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.