Question description:
This user has given permission to use the problem statement for this
blog.
Hello, I have two separate sentences written in two separate cells (A1 & B1). If in another cell the answer to a question is 'Client' or 'PDI' for example. I want a formula that will select the correct text from either cell A1 or B1.
i.e. 'Client' - Pulls text from A1. If PDI - Pulls text from B1
Solved by V. Y. in 22 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
23/04/2018 - 01:56
Welcome to got it pro.
Excelchat Expert
23/04/2018 - 01:56
I understand you want help with a formula.
User
23/04/2018 - 01:56
Yes, I certainly do. It's extremely simple too. I just can't figure it out!!
Excelchat Expert
23/04/2018 - 01:58
I'm here to help, so don't worry.
Excelchat Expert
23/04/2018 - 01:58
After this session, you will be able to master it.
Excelchat Expert
23/04/2018 - 01:58
So, can you show me in the preview window what do you want?
User
23/04/2018 - 01:59
yes.. will do
Excelchat Expert
23/04/2018 - 02:00
Thanks.
Excelchat Expert
23/04/2018 - 02:03
Please let me know when you are finished.
User
23/04/2018 - 02:07
Okay so.. If the text in cell B12 is PDI, I want the sentence in my formula cell to choose the text in cell A16. If however, the text in cell B15 is Client, I want the sentence in my formula cell to pick up the text in A15. Does that make sense?
Excelchat Expert
23/04/2018 - 02:08
Yeah, where do you want the formual?
User
23/04/2018 - 02:08
Sorry.. Both cells should be B12 with text PDI or Client as the options
Excelchat Expert
23/04/2018 - 02:08
*formula
Excelchat Expert
23/04/2018 - 02:09
understood.
User
23/04/2018 - 02:09
On a separate tab
Excelchat Expert
23/04/2018 - 02:10
got it. thanks, I will write the formula now.
User
23/04/2018 - 02:10
Thank you..
Excelchat Expert
23/04/2018 - 02:11
Please take a look at Sheet2, cell A1.
Excelchat Expert
23/04/2018 - 02:11
the formula is =IF(Sheet1!B12="PDI",Sheet1!A16,Sheet1!A15)
Excelchat Expert
23/04/2018 - 02:12
makes sense?
User
23/04/2018 - 02:13
Will that pick up if the cell reads 'client' and not PDI, the text from A15 will be picked up?
Excelchat Expert
23/04/2018 - 02:14
Yeah, The syntax of IF is =IF(logical-test,value-if-true,value-if-false)
Excelchat Expert
23/04/2018 - 02:14
So, our logical test contains two options, either PDI or Client.
Excelchat Expert
23/04/2018 - 02:15
In the formula, we are checking Whether B12 is PDI or not, IF true, formula will show the value of A16. But if not true, that means the value of B12 is Client and thus will show result form B15.
Excelchat Expert
23/04/2018 - 02:15
making sense?
User
23/04/2018 - 02:16
Yes I see now.. Thank you so much for your help
Excelchat Expert
23/04/2018 - 02:16
I'm glad that you got the help you needed.
Excelchat Expert
23/04/2018 - 02:16
Please ask me questions if you have any regarding the solution.
Excelchat Expert
23/04/2018 - 02:17
Otherwise, please close this chat session now. I believe there is a close/end button on your side.
User
23/04/2018 - 02:17
No, I think I'm good now.. Thanks
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.
