problem with entering month of the year
 

I am using the following formula to display in cell xx £200 ( I have
altered this slightly as it used to display two different values, 150/200 to
200/200)

=CHOOSE(MATCH(D7,{0;5;7;11},1),"",200,200,"")

The value (£s) is triggered by the month of the year 06/07/08/09 etc, I had
a person fill in the form using Sept rather than 09 and the displayed N/A

Is there a way around this? Or does it just complicate things too much.

thanks

problem with entering month of the year
 

Couldn't use just use Editfind and replace to change the months back to
figures
--
RWS


"S S" wrote:

I am using the following formula to display in cell xx £200 ( I have
altered this slightly as it used to display two different values, 150/200 to
200/200)

=CHOOSE(MATCH(D7,{0;5;7;11},1),"",200,200,"")

The value (£s) is triggered by the month of the year 06/07/08/09 etc, I had
a person fill in the form using Sept rather than 09 and the displayed N/A

Is there a way around this? Or does it just complicate things too much.

thanks

problem with entering month of the year
 

You could amend formula to cope with Text months only

=CHOOSE(MATCH(MONTH("1-"&D7),{0;5;7;11},1),"",200,200,"")

or to handle either "sept" or 09

=CHOOSE(MATCH(IF(ISTEXT(D7),MONTH("1-"&D7),D7),{0;5;7;11},1),"",200,200,"")

although it might be simpler to use LOOKUP rather than CHOOSE/MATCH

=LOOKUP(IF(ISTEXT(D7),MONTH("1-"&D7),D7),{0;5;7;11},{"",200,200,""})


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=554320