# Excel - COLUMN Function Problem - Expert Solution

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

Hello. I would like to create a drop down option to choose Square Feet or Square Meters. Next column they insert the amount and the next it converts the value to whatever is chosen from the drop down option. Can you help please?
Solved by Z. Q. in 39 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 23/10/2017 - 11:30
Hello! Thanks for choosing Got It Pro-Excel.
Excelchat Expert 23/10/2017 - 11:31
Excelchat Expert 23/10/2017 - 11:31
Helloo
Excelchat Expert 23/10/2017 - 11:32
in session
User 23/10/2017 - 11:33
thanks
Excelchat Expert 23/10/2017 - 11:33
you're welcome
Excelchat Expert 23/10/2017 - 11:33
Would you mine to share with us the file containing about the Square feet or square meters?
Excelchat Expert 23/10/2017 - 11:33
In this way, we could support you to create the dropdown list
User 23/10/2017 - 11:34
I haven't got a file. I know how to create a drop down list
User 23/10/2017 - 11:34
i want to create a drop down option..Square feet & square Meters
User 23/10/2017 - 11:34
next cell hey insert the mount
User 23/10/2017 - 11:35
the following cells returns a value
Excelchat Expert 23/10/2017 - 11:35
Yes, Got it. But, I hope to see your references for the computation
Excelchat Expert 23/10/2017 - 11:36
We must set up the values for each square feet or Square meters
Excelchat Expert 23/10/2017 - 11:36
can you give us the formula, so we could create this for you?
Excelchat Expert 23/10/2017 - 11:38
Alright, I'm going to create this for you using Excel on my desktop then upload the file for you.
Excelchat Expert 23/10/2017 - 11:38
is this works for you?
User 23/10/2017 - 11:38
sure does
Excelchat Expert 23/10/2017 - 11:38
thank you.
Excelchat Expert 23/10/2017 - 11:38
please give me few moment for this
Excelchat Expert 23/10/2017 - 11:41
Once a person input a number in , example. 2 , what will be your expected result?
User 23/10/2017 - 11:43
example - i choose square feet from the drop down menu. I insert 500 in the next cell
User 23/10/2017 - 11:43
i want excel to automatically convert to sqm
User 23/10/2017 - 11:44
and visa versa
Excelchat Expert 23/10/2017 - 11:44
alright, do you have any idea how many feet in 1 meter?
Excelchat Expert 23/10/2017 - 11:45
Just searching it, for a moment
User 23/10/2017 - 11:45
we use the number as a whole..so if i insert 500 sq meters i times it by 10.7639104
User 23/10/2017 - 11:46
if i insert 10,000 i divide by 10.7639104
User 23/10/2017 - 11:46
10,000 sq ft*
Excelchat Expert 23/10/2017 - 11:47
okay, thanks
Excelchat Expert 23/10/2017 - 11:47
I'm creating it, please extend our time
Excelchat Expert 23/10/2017 - 12:01
https://www.dropbox.com/s/i5mcclmrbuzfstf/convert%20ft%20to%20meter%20in%20a%20dropdown%20list.xlsx?dl=0
Excelchat Expert 23/10/2017 - 12:02
Excelchat Expert 23/10/2017 - 12:04
hello
Excelchat Expert 23/10/2017 - 12:08
hello there

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.