Excel - IF Function Problem - Expert Solution

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

Basically I want to say if E5 is in B5, then put the value of C5 in F5 etc
Solved by B. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 25/07/2018 - 03:21
Hello
Excelchat Expert 25/07/2018 - 03:21
Welcome to got it pro
Excelchat Expert 25/07/2018 - 03:22
may i know your problem that want to solve?
Excelchat Expert 25/07/2018 - 03:24
Hello
Excelchat Expert 25/07/2018 - 03:29
i think your problem was if the value in E5 is equal in B5, value of F5 would be the value of C5 is in it?
Excelchat Expert 25/07/2018 - 03:29
i already put an example
Excelchat Expert 25/07/2018 - 03:29
wherein B5 & E5 has an equal value of "Ball"
Excelchat Expert 25/07/2018 - 03:30
thats why if the value of f5 now was the value in C5
Excelchat Expert 25/07/2018 - 03:31
so if we change the value of b5,
Excelchat Expert 25/07/2018 - 03:31
F5 would be blank, since B5 & E5 will be not similar now
Excelchat Expert 25/07/2018 - 03:32
i only use the formula IF function for this
Excelchat Expert 25/07/2018 - 03:32
=if(E5=B5,C5,"")
Excelchat Expert 25/07/2018 - 03:32
here it is
Excelchat Expert 25/07/2018 - 03:33
so if E5 & B5 are equal, value would be C5 else it will be blank
Excelchat Expert 25/07/2018 - 03:33
i think this was the solution that you want
Excelchat Expert 25/07/2018 - 03:33
if you still have problem that you want to solve, just raise the question again so we can solve it here :)
Excelchat Expert 25/07/2018 - 03:34
it looks like you we are disconnected,
Excelchat Expert 25/07/2018 - 03:34
i'm hoping you came back again,
Excelchat Expert 25/07/2018 - 03:34
by the way thanks for using the got it pro.

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.