Excel - IF Function Problem - Expert Solution

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

I need to find values in G1 to G30(30 values) in H1 to H100(100 values). if within 100 ,the given 30 matches.
Solved by G. H. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 23/05/2018 - 12:29
Hello, how are you?
User 23/05/2018 - 12:30
User 23/05/2018 - 12:30
User 23/05/2018 - 12:31
how to check if values given in E are there in values given in C
Excelchat Expert 23/05/2018 - 12:31
I have read through your query, o you mind uploading the excel file so that I can examine it locally?
User 23/05/2018 - 12:31
i have just copies the data u need on right
User 23/05/2018 - 12:31
User 23/05/2018 - 12:32
?? anyone there?
Excelchat Expert 23/05/2018 - 12:32
Yes I am here
User 23/05/2018 - 12:33
u got my question?
Excelchat Expert 23/05/2018 - 12:33
Trying to figure it out
User 23/05/2018 - 12:33
User 23/05/2018 - 12:34
can all values be checked alltogether or i have to do it one at a time
Excelchat Expert 23/05/2018 - 12:34
What should be the expected output and where should it be?
Excelchat Expert 23/05/2018 - 12:34
They can be checked
User 23/05/2018 - 12:35
if there is any value which matches should be given in a separate cpolumn
Excelchat Expert 23/05/2018 - 12:35
So you just want to confirm if the values match, am assuming that
User 23/05/2018 - 12:36
if there is any value which is in column E and also in column C . it shud be highlighted of taken out
Excelchat Expert 23/05/2018 - 12:38
Okay, please check if that makes sense
[Uploaded an Excel file]
Excelchat Expert 23/05/2018 - 12:39
Are you there?
User 23/05/2018 - 12:39
perfect. got it
User 23/05/2018 - 12:39
Excelchat Expert 23/05/2018 - 12:39
You are so welcome. Please remember to rate me well after closing the session. A 5star will be kind enough. And a nice comment if you don’t mind.
User 23/05/2018 - 12:40
Excelchat Expert 23/05/2018 - 12:40
Am waiting
Excelchat Expert 23/05/2018 - 12:40
Any trouble?
User 23/05/2018 - 12:40
na.... got it ..
User 23/05/2018 - 12:40
thanks alot man
User 23/05/2018 - 12:40
how to rate?
Excelchat Expert 23/05/2018 - 12:41
cool, you will see the option to rate after closing the session
User 23/05/2018 - 12:41

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.

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
The Allstate Corporation
United Parcel Service
Dell Inc