Excel - IF Function Problem - Expert Solution

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

I am hoping you can help me. I have one spreadsheet that has standard audit comments and I have a standard comment column for yes and a standard comment column for No. when I go to audit visits I use another sheet to record the visit use an if Statement to return the value of the cell. =IF(P9="yes",'2018 Preschool Wordings'!M8,IF(P9="No",'2018 Preschool Wordings'!N8,"")) once I have the content in the cell I normally need to modify the content slightly depending on the circumstances. the comments can be quite lengthy. but my formula wont show me the values to then allow me to modify. help
Solved by C. C. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 09/10/2018 - 01:01
Hello, welcome to got it pro
User 09/10/2018 - 01:02
does my question make sense.
Excelchat Expert 09/10/2018 - 01:02
do you have your file so we can check on that?
User 09/10/2018 - 01:03
I do but can you guarantee that it will be deleted after.
Excelchat Expert 09/10/2018 - 01:03
yes,
Excelchat Expert 09/10/2018 - 01:04
any file you send us, you can assure that it was only for the both of us
Excelchat Expert 09/10/2018 - 01:04
or maybe you could delete some part if you think that was very confidential
Excelchat Expert 09/10/2018 - 01:06
you may also try this formula if this will works on your file
Excelchat Expert 09/10/2018 - 01:06
=IF(P9="yes",'2018 Preschool Wordings'!M8,'2018 Preschool Wordings'!N8)
User 09/10/2018 - 01:06
can you see my file
[Uploaded an Excel file]
Excelchat Expert 09/10/2018 - 01:07
checking
Excelchat Expert 09/10/2018 - 01:07
yes im able to open it now
Excelchat Expert 09/10/2018 - 01:07
on which sheet you are referring on your problem?
User 09/10/2018 - 01:08
icq visit review - look at Q S and T in row 4
User 09/10/2018 - 01:09
I need to modify these comments during a visit.
Excelchat Expert 09/10/2018 - 01:10
ok checking
Excelchat Expert 09/10/2018 - 01:11
what is not functioning right here?
User 09/10/2018 - 01:12
on the ICQ visit review sheet - I want the formula to show me the value of the cell so I can modify the standard comment.
Excelchat Expert 09/10/2018 - 01:13
value you mean the comments?
User 09/10/2018 - 01:13
yes
Excelchat Expert 09/10/2018 - 01:13
where the comments be located?
User 09/10/2018 - 01:14
the formula gets the comments come from the 2018 preschool wording sheet.
Excelchat Expert 09/10/2018 - 01:14
yes
Excelchat Expert 09/10/2018 - 01:15
and then you want to edit the comments right?
User 09/10/2018 - 01:15
yes
Excelchat Expert 09/10/2018 - 01:15
you can change it on the "2018 Preschool Wordings" sheet
User 09/10/2018 - 01:16
I don't want to change the standard wording.
Excelchat Expert 09/10/2018 - 01:16
ok
Excelchat Expert 09/10/2018 - 01:16
so which one you want to edit?
Excelchat Expert 09/10/2018 - 01:18
you could extend our time
Excelchat Expert 09/10/2018 - 01:18
so we could finish your template
User 09/10/2018 - 01:18
please don't worry I will work it out - please delet this sheet. thank you
Excelchat Expert 09/10/2018 - 01:19
oh wait, i can help you here
Excelchat Expert 09/10/2018 - 01:19
just tell me the exact solution that you want
Excelchat Expert 09/10/2018 - 01:19
so we can work it out
User 09/10/2018 - 01:21
I want to be able to modify the contents of cell Q4 in the ICQ visit review sheet once the formula has downloaded the content
Excelchat Expert 09/10/2018 - 01:22
ok
Excelchat Expert 09/10/2018 - 01:22
so if the comments appear on the box, you just want to slighlty edit this right?
User 09/10/2018 - 01:23
yes
Excelchat Expert 09/10/2018 - 01:23
what kind of edit, you want to add text or removing something?
Excelchat Expert 09/10/2018 - 01:24
if you will just adding some text we can do that in formula
User 09/10/2018 - 01:24
both - there is a way that the formula can provide just the value of the field which would then allow me to change content.
Excelchat Expert 09/10/2018 - 01:25
if we are removing some text, it will not be possible on a formula
User 09/10/2018 - 01:25
ok thanks for your help. I will think of another option.
Excelchat Expert 09/10/2018 - 01:25
what we can do on that was paste special
Excelchat Expert 09/10/2018 - 01:26
copy the cell value then use the paste special for that cell
Excelchat Expert 09/10/2018 - 01:26
but the formula will might remove because of that
User 09/10/2018 - 01:27
so how do I use an if statement then to tell it what to answer for yes and what to answer for no
User 09/10/2018 - 01:28
I want the formula removed\
Excelchat Expert 09/10/2018 - 01:28
for that one we need the formula the IF statement to get the answer for Yes & No
Excelchat Expert 09/10/2018 - 01:29
en if you will be going to edit the comments, thats the time we will used the paste special for that cell
Excelchat Expert 09/10/2018 - 01:29
on a way we can edit the comments
User 09/10/2018 - 01:29
so there is not way to build the value into the formula - so I would have to copy paste special for each cell ?
Excelchat Expert 09/10/2018 - 01:29
then if you will need to change the yes/no just copy paste again the formula for that cell
Excelchat Expert 09/10/2018 - 01:30
yes, since we are only looking up the value of the comments on the other sheet
User 09/10/2018 - 01:30
ok, thank you for your help.
Excelchat Expert 09/10/2018 - 01:30
the only way to change that, is to modify the text on the sheet where we are lookin gup
Excelchat Expert 09/10/2018 - 01:31
are you good on that now?
User 09/10/2018 - 01:31
yes - thank you - can you please permanently delete this sheet.
Excelchat Expert 09/10/2018 - 01:31
yes
Excelchat Expert 09/10/2018 - 01:31
Is there anything else I can help you with?

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.