=IF(AND('SWF08'!$A$2:$A$1905=FallBookings!$C3,'SWF 08'!$G$2:$G$1905=FallBookings!$F3),"OK","Review
Finish Date")

Excel 2003
I have tried the above formula but no luck even as an array. I want to check
the date entered in cell F3 against 2 conditions on another sheet, SWF08.
The 2 conditions in sheet FallBookings should be tied to the SWF08 sheet
ranges a2:a1905,g2:g1905 and return one unique "true" else I need to review
the date entered in F3 on FallBookings worksheet. I had thought about
sumproduct() but don't know how to get it to return a text value, so I went
to the if(and()) with "Review Finish Date" results for all the cells even
though I know the value is ok.
I think the formula should be something like, if these 2 cells conditions on
sheet A are met when compared against these 2 ranges of cells on sheet B,
then ok else review entry in cell f3. The data is an item number a2:a1905
and date g2:g1905. In the words of the Highlander, there can be only one.
Thanks to all for looking and any help is greatly appreciated.
Lee

Think you could try it like this:
=IF(SUMPRODUCT((SWF08!$A$2:$A$1905=FallBookings!$C 3)*(SWF08!$G$2:$G$1905=FallBookings!$F3))0,"OK"," Review
Finish Date")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400, Files:358, Subscribers:55
xdemechanik
---
"Neophyte" wrote in message
...
=IF(AND('SWF08'!$A$2:$A$1905=FallBookings!$C3,'SWF 08'!$G$2:$G$1905=FallBookings!$F3),"OK","Review
Finish Date")

Excel 2003
I have tried the above formula but no luck even as an array. I want to
check the date entered in cell F3 against 2 conditions on another sheet,
SWF08. The 2 conditions in sheet FallBookings should be tied to the SWF08
sheet ranges a2:a1905,g2:g1905 and return one unique "true" else I need to
review the date entered in F3 on FallBookings worksheet. I had thought
about sumproduct() but don't know how to get it to return a text value, so
I went to the if(and()) with "Review Finish Date" results for all the
cells even though I know the value is ok.
I think the formula should be something like, if these 2 cells conditions
on sheet A are met when compared against these 2 ranges of cells on sheet
B, then ok else review entry in cell f3. The data is an item number
a2:a1905 and date g2:g1905. In the words of the Highlander, there can be
only one.
Thanks to all for looking and any help is greatly appreciated.
Lee

Thanks it worked great. Why the 0? Is it the True/False thing on
sumproduct? Unfortunatly, it returned Review dates so now I have more work
but I can pinpoint the mistakes.
Thanks again,
Lee
"Max" wrote in message
...
Think you could try it like this:
=IF(SUMPRODUCT((SWF08!$A$2:$A$1905=FallBookings!$C 3)*(SWF08!$G$2:$G$1905=FallBookings!$F3))0,"OK"," Review
Finish Date")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400, Files:358, Subscribers:55
xdemechanik
---
"Neophyte" wrote in message
...
=IF(AND('SWF08'!$A$2:$A$1905=FallBookings!$C3,'SWF 08'!$G$2:$G$1905=FallBookings!$F3),"OK","Review
Finish Date")

Excel 2003
I have tried the above formula but no luck even as an array. I want to
check the date entered in cell F3 against 2 conditions on another sheet,
SWF08. The 2 conditions in sheet FallBookings should be tied to the SWF08
sheet ranges a2:a1905,g2:g1905 and return one unique "true" else I need
to review the date entered in F3 on FallBookings worksheet. I had thought
about sumproduct() but don't know how to get it to return a text value,
so I went to the if(and()) with "Review Finish Date" results for all the
cells even though I know the value is ok.
I think the formula should be something like, if these 2 cells conditions
on sheet A are met when compared against these 2 ranges of cells on
sheet B, then ok else review entry in cell f3. The data is an item number
a2:a1905 and date g2:g1905. In the words of the Highlander, there can be
only one.
Thanks to all for looking and any help is greatly appreciated.
Lee

Thanks it worked great.
Welcome, that's good

Why the 0? Is it the True/False thing on sumproduct?
Yes, the product of the 2 conditional arrays produces a resultant array of
1's & 0's, depending on whether the simultaneous criteria is satisfied or
not. Sumproduct then adds it up, hence the 0 check gives you the final
TRUE/FALSE result within the IF.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400, Files:358, Subscribers:55
xdemechanik
---