Excel - COLUMN Function Problem - Expert Solution

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

I am trying to add a name to column C when column B is null =IF(B2 is null,E2,B2) I am getting the #NAME?
Solved by O. S. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 15/05/2018 - 02:06
Hello :)
User 15/05/2018 - 02:06
Good morning
Excelchat Expert 15/05/2018 - 02:06
Can you show me an example of what you're looking for on the sheet to the right?
User 15/05/2018 - 02:08
some of my A2 fields have names in them, the ones that don't need to have the name from D2
Excelchat Expert 15/05/2018 - 02:08
Okay, so in this is example, is C and D acting as A and D?
User 15/05/2018 - 02:09
Excelchat Expert 15/05/2018 - 02:09
Okay, I'm going to adjust so that it is exact how you want it.
Excelchat Expert 15/05/2018 - 02:10
Excelchat Expert 15/05/2018 - 02:10
Please see the formula in F2.
User 15/05/2018 - 02:10
that works perfectly - thank you!
Excelchat Expert 15/05/2018 - 02:11
You're very welcome.
Excelchat Expert 15/05/2018 - 02:11
Did you have any questions?
User 15/05/2018 - 02:11
no sir...thank you very much!
Excelchat Expert 15/05/2018 - 02:11
My pleasure. Please sure to end the session and rate the service received today :)
Excelchat Expert 15/05/2018 - 02:12
Also, kind words for positive ratings go a long way :)

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