Excel - IF Function Problem - Expert Solution

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

I have a list of values in one coloumn and i want to use an if function. If the value in cell A matches any of cells B2:B400 then true return 1, if false return 2
Solved by V. U. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 16/03/2018 - 06:49
Thanks for choosing Got It Pro. I’m happy to be able to help you today.
User 16/03/2018 - 06:50
Excelchat Expert 16/03/2018 - 06:50
I’d love to help you with your problem if you would kindly give me more information.
User 16/03/2018 - 06:50
User 16/03/2018 - 06:51
So i want to use an IF function
Excelchat Expert 16/03/2018 - 06:51
Excelchat Expert 16/03/2018 - 06:51
ok I am making
User 16/03/2018 - 06:51
Id like to know if, the package ID is in the New Package ID column then to return Yes, if false return No
Excelchat Expert 16/03/2018 - 06:51
User 16/03/2018 - 06:52
Ahhh okay, so the match function is much better to use than the =
Excelchat Expert 16/03/2018 - 06:53
Excelchat Expert 16/03/2018 - 06:53
Please check
User 16/03/2018 - 06:54
Okay yeah i think that has worked for me
User 16/03/2018 - 06:55
Could you give me a workings of how that functionality works
Excelchat Expert 16/03/2018 - 06:55
Yes sure
User 16/03/2018 - 06:55
Is there any way of changing True to a word
User 16/03/2018 - 06:55
So True became Water and False became Wine
Excelchat Expert 16/03/2018 - 06:55
I am writing now
User 16/03/2018 - 06:55
Or is that not possible?
Excelchat Expert 16/03/2018 - 06:55
Yes you can change your own
Excelchat Expert 16/03/2018 - 06:56
Check i have changed
User 16/03/2018 - 06:56
Okay thats grerat
Excelchat Expert 16/03/2018 - 06:57
Excelchat Expert 16/03/2018 - 06:58
Is there anything else you want to know regarding this issue?
User 16/03/2018 - 06:58
No that looks great
Excelchat Expert 16/03/2018 - 06:58
Thanks for using Got It Pro. Please give your kind feedback for our service.Have a good day ahead.

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