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.