Need to flag 3 items on 3 different worksheets

[daniels012]

I have 3 columns on Sheet 1
Date, Field, Times

Sheet 2 and Sheet 3 also has these.
What I want to do is keep from any duplicates happening

So if Sheet 1 has:
2/25/2011 Field #3 5:30pm
And on Sheet 3 has:
2/25/2011 Field #3 5:30pm
Then I need something to flag. I really want to do this without conditional formatting or VBA. I want a formula in a helper cell in say Column 7 that will say "Duplicate" or "Something scheduled".
If this is impossible to do, let me know that as well.

Thank You,
Michael

 

[GNB]

An easy way to do this will be to set up another couple of cells on each table.

Excel Workbook
	A	B	C	D	E	F	G	H
1	Date	Field	Time	Status		Conflict with Sheet2	Conflict with Sheet3	Code
2	21/02/2011	Field 1	17:00	Conflict with Sheet2		ERROR	OK	40595 Field 1 0.708333333333333
3	15/02/2011	Field 3	19:00	OK		OK	OK	40589 Field 3 0.791666666666667
4	1/03/2011	Field 2	19:00	OK		OK	OK	40603 Field 2 0.791666666666667
Sheet1

Excel 2007

Cell Formulas
Range	Formula
F2	=IF(IFERROR(VLOOKUP(H2,Sheet2!E2:E5,1,FALSE),"OK")<>"OK","ERROR","OK")
F3	=IF(IFERROR(VLOOKUP(H3,Sheet2!E3:E6,1,FALSE),"OK")<>"OK","ERROR","OK")
F4	=IF(IFERROR(VLOOKUP(H4,Sheet2!E4:E7,1,FALSE),"OK")<>"OK","ERROR","OK")
G2	=IF(IFERROR(VLOOKUP(H2,Sheet3!E2:E5,1,FALSE),"OK")<>"OK","ERROR","OK")
G3	=IF(IFERROR(VLOOKUP(H3,Sheet3!E3:E6,1,FALSE),"OK")<>"OK","ERROR","OK")
G4	=IF(IFERROR(VLOOKUP(H4,Sheet3!E4:E7,1,FALSE),"OK")<>"OK","ERROR","OK")
H2	=CONCATENATE(A2," ",B2," ",C2)
H3	=CONCATENATE(A3," ",B3," ",C3)
H4	=CONCATENATE(A4," ",B4," ",C4)
D2	=IF(F2="ERROR",F1,IF(G2="ERROR",G1,"OK"))
D3	=IF(F3="ERROR",F2,IF(G3="ERROR",G2,"OK"))
D4	=IF(F4="ERROR",F3,IF(G4="ERROR",G3,"OK"))

This wont be the most efficient way but will work if you set this up on each table.

HTH