Excel - COLUMN Function Problem - Expert Solution

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

Hi, I need help with a formula, below is example of what I am looking for - with formula to be entered into C3, the letters entered in column 2 will be associated with values (e.g. FCA = 11, FOB = 15, DAP = 21) to add to the date in column 1: 1 2 3 A 01/01/2000 FCA ? B 01/01/2000 FOB ? C 01/01/2000 DAP ? Please help?
Solved by O. C. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 31/05/2018 - 04:04
Excelchat Expert 31/05/2018 - 04:04
Welcome to excelchat, we are happy to have you today with us.
User 31/05/2018 - 04:06
Hi, this for personal use
Excelchat Expert 31/05/2018 - 04:06
Good to know.
Excelchat Expert 31/05/2018 - 04:07
Do you have a working excel file? If so, I would like to see it to understand the problem clearly.
User 31/05/2018 - 04:08
not as of yet - what part of my explanation isn't clear, can I help that way?
Excelchat Expert 31/05/2018 - 04:08
Please show me the data in the preview window.
Excelchat Expert 31/05/2018 - 04:09
Actually what you wrote in the description is kind of got jumbled at the end and it is hard to understand.
User 31/05/2018 - 04:09
Ok, the main issue I have is I don't want to make a separate table, I wish to insert the required values to add to the date in the formula - as there will only be 3 different text values in the other column
User 31/05/2018 - 04:10
let me try to explain on preview window
Excelchat Expert 31/05/2018 - 04:10
Thank you.
User 31/05/2018 - 04:12
I will show in the C column what the answer should be but I need a formula to populate this automatically depending on what is entered into column B
Excelchat Expert 31/05/2018 - 04:12
I'm listening..
User 31/05/2018 - 04:13
Does that kind of make sense?
Excelchat Expert 31/05/2018 - 04:14
Yeah, totally, thanks for making it clear.
Excelchat Expert 31/05/2018 - 04:14
I need a few minutes.
Excelchat Expert 31/05/2018 - 04:15
Just so you know, when you input dates in excel cell, excel automatically reads the dates as Months/Days/Year format.
User 31/05/2018 - 04:16
Yeah sorry, to be fair in my sheet I will show it as this...
Excelchat Expert 31/05/2018 - 04:16
So, when you wrote 01/01/2000, excel reads it as 1 January 2000
User 31/05/2018 - 04:17
yes sorry, blame the English in me haha
Excelchat Expert 31/05/2018 - 04:18
Excelchat Expert 31/05/2018 - 04:18
Here is the formula you need.
Excelchat Expert 31/05/2018 - 04:19
Please let me know if you have question.
User 31/05/2018 - 04:20
Do you not have to put 'DAP' in the formula anywhere for if I put DAP into a cell? or does it automatically put 21 in for anything that is not 'FCA' or 'FOB'?
Excelchat Expert 31/05/2018 - 04:20
Yeah, you are correct, if automatically put 21 that is not FCA or FOB
User 31/05/2018 - 04:21
Ok great stuff, thank you for your help, I will definitely be back to this site! Great help!
Excelchat Expert 31/05/2018 - 04:22
Thanks for the appreciation.
Excelchat Expert 31/05/2018 - 04:22
I would love if you can leave a 5 star rating and a good comment on my service.
Excelchat Expert 31/05/2018 - 04:22
The session will end in 1 minute, after that you can rate me or you can opt to end it now and rate me.
Excelchat Expert 31/05/2018 - 04:22
Thanks again and have a great day.

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