Excel - IF Function Problem - Expert Solution

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

I am trying to see if the items in column A are also included in column B.
Solved by A. U. in 29 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 01/03/2017 - 05:18
Hello sir.
User 01/03/2017 - 05:18
I don't believe so. Can I share the spreadsheet with you?
Excelchat Expert 01/03/2017 - 05:18
Yes.
User 01/03/2017 - 05:19
are you able to see it?
Excelchat Expert 01/03/2017 - 05:19
No sir I cant see it.
User 01/03/2017 - 05:22
is there something special I need to do to upload the document?
Excelchat Expert 01/03/2017 - 05:23
I think not. U just press the clip and upload it.
User 01/03/2017 - 05:23
I did that
Excelchat Expert 01/03/2017 - 05:23
[Uploaded an Excel file]
Excelchat Expert 01/03/2017 - 05:24
Upload google drive and share the link then.
Excelchat Expert 01/03/2017 - 05:24
it was just a test.
User 01/03/2017 - 05:26
https://drive.google.com/file/d/0B0Edk3SPt25GaXc3YlYwY05fV0E/view?usp=sharing
Excelchat Expert 01/03/2017 - 05:27
One moment, Sir.
User 01/03/2017 - 05:28
are you able to access the spreadsheet?
Excelchat Expert 01/03/2017 - 05:28
It wont load.
Excelchat Expert 01/03/2017 - 05:28
Maybe it will load for my colleagues, wait a minute
Excelchat Expert 01/03/2017 - 05:31
Yes I can see it sir
Excelchat Expert 01/03/2017 - 05:32
So you want to find out if A is also in B?
User 01/03/2017 - 05:32
yes
Excelchat Expert 01/03/2017 - 05:34
As i can see there ar no Data in column B.
Excelchat Expert 01/03/2017 - 05:39
Sir?
User 01/03/2017 - 05:39
what do you mean?
User 01/03/2017 - 05:39
there is data in columns a and b
Excelchat Expert 01/03/2017 - 05:39
The data on B is blank
User 01/03/2017 - 05:39
it is spreadsheet #3
Excelchat Expert 01/03/2017 - 05:40
Oh sorry Sir now I see.
Excelchat Expert 01/03/2017 - 05:41
But i dont really get your question, can you describe it more
User 01/03/2017 - 05:42
I need to know if the numbers that are in column A are also in column B
Excelchat Expert 01/03/2017 - 05:46
The time is running out, we can solve your problem, when session ends go take another one.
Excelchat Expert 01/03/2017 - 05:47
Okey?
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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc