Excel - IF Function Problem - Expert Solution

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
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
Excelchat Expert 23/04/2018 - 02:09
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.

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc