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
Hi
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
Hey
User
16/03/2018 - 06:51
So i want to use an IF function
Excelchat Expert
16/03/2018 - 06:51
Hello
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
ok
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
Done
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
done
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.
