Help please with formula



This is the formula I am using...


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

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.

Bob Phillips

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?


Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads