EXCEL VLOOKUP or MATCH fx Problem

  • Thread starter Thread starter hjdavies
  • Start date Start date
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
 
You haven't closed off your MATCH function - Try this:-

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