EXCEL VLOOKUP or MATCH fx Problem

[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

 

[Ken Wright]

You haven't closed off your MATCH function - Try this:-

=CHOOSE(MATCH(A1,{"house1","house2","house3","house4"},0),100,200,300,400)

 

[Frank Kabel]

Hi
there is an error in your formula (missing parenthesis). Try
=CHOOSE(MATCH(A1,{"house1","house2","house3","house4"},0),100,200,300,4
00)