**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

i'M SO GLAD TO SUPPORT YOU TODAY ABOUT YOUR DROPDOWN LIST

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

Please download my dropbox file and check. Hope it works.

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.*