H
hjdavies
I am attempting to create a simple excel form where the user can choos
a house name and the square footage will appear for each plan. Fo
example, when you choose house1, 100 appears in the next cell, when yo
choose house 2, 200 appears, etc. I have created a form using th
formul
=CHOOSE(MATCH(A1,{"house1","house2","house3","house4"},100,200,300,400)
The problem is EXCEL is not recognizing the values over house3. When
select house 4 from my validation menu, it will have either an erro
message or a different value.
Any help will be much appreciated
Attachment filename: brick take off form.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46547
a house name and the square footage will appear for each plan. Fo
example, when you choose house1, 100 appears in the next cell, when yo
choose house 2, 200 appears, etc. I have created a form using th
formul
=CHOOSE(MATCH(A1,{"house1","house2","house3","house4"},100,200,300,400)
The problem is EXCEL is not recognizing the values over house3. When
select house 4 from my validation menu, it will have either an erro
message or a different value.
Any help will be much appreciated
Attachment filename: brick take off form.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46547