View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S S
 
Posts: n/a
Default Help please with formula

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.