This is the formula I am using...

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

A set of dates are entered 1st july to 15 July (dates before this would be
£150)

It should return in say A1 £200
It should return in sat A2 £200

In A1 I am getting #N/A

Can anyone spot the error as I dont understand it.

Date in D7 I assume?

there is nothing in the formula to compare a date, so it will always return
4 from MATCH, which will get "" from the list.

Where did you get this from?

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"S S" wrote in message
.uk...
This is the formula I am using...

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

A set of dates are entered 1st july to 15 July (dates before this would
be
£150)

It should return in say A1 £200
It should return in sat A2 £200

In A1 I am getting #N/A

Can anyone spot the error as I dont understand it.