Hi,

I need to create a forumulae which checks data against the appropraite rows.

For example:

They need to search the worksheet for the corresponding row and then check
the date from that row against the current cell and output if the date is
earlier or later. I tried using an IF statement where I compared the cells
against each other but this didn't work.

I thought that something like a FOR or WHERE statement would be better but I
cannot work out how to create one in excel. It would have to probably read
something like:

WHERE column a = column b
IF date 1 date 2
earlier
ELSE
later

Sorry if this doesn't make sense I'm not sure how to phrase it.

Thanks.