Searching and matching in sheet (urgent)
 

Hello

I have the following problem .. and I can't find the way to solve it.

this is my screencapture of excel table:
http://www.fuchka.info/tmp/excelproblem.jpg

What I need is function that will:

A) check for occurence of N12 in columns N or Q or T
B) when found it should take the date from cell M5 and
C) subtract the date in cell B12 from date in cell M5
D) If result is zero or above it should write "VALID" to cell E12,
otherwise it should write "INVALID"

thanks for any help.

Searching and matching in sheet (urgent)
 

=IF(AND(OR(N120,Q120,T120),(M5-B12)=0),"VALID","INVALID")

" wrote:

Hello

I have the following problem .. and I can't find the way to solve it.

this is my screencapture of excel table:
http://www.fuchka.info/tmp/excelproblem.jpg

What I need is function that will:

A) check for occurence of N12 in columns N or Q or T
B) when found it should take the date from cell M5 and
C) subtract the date in cell B12 from date in cell M5
D) If result is zero or above it should write "VALID" to cell E12,
otherwise it should write "INVALID"

thanks for any help.