Multiple MATCH with WORKDAY

[tiredofit]

Here is my data:

Col A          Col B                   Col D           Col E
[TABLE="width: 342"]
<tbody>[TR]
[TD="align: right"]01/01/2010[/TD]
[TD]a[/TD]
[TD][/TD]
[TD="align: right"]31/12/2009[/TD]
[TD] a[/TD]
[/TR]
[TR]
[TD="align: right"]02/01/2010[/TD]
[TD]b[/TD]
[TD][/TD]
[TD="align: right"]01/01/2010[/TD]
[TD] b[/TD]
[/TR]
[TR]
[TD="align: right"]03/01/2010[/TD]
[TD]c[/TD]
[TD][/TD]
[TD="align: right"]02/01/2010[/TD]
[TD] c[/TD]
[/TR]
[TR]
[TD="align: right"]04/01/2010[/TD]
[TD] d[/TD]
[TD][/TD]
[TD="align: right"]03/01/2010[/TD]
[TD] d[/TD]
[/TR]
</tbody>[/TABLE]

In cell G1, I type:

=MATCH(1,(B1=E1:E4)*(A1<=WORKDAY(D1:D4,3)),0)

and enter it as an ARRAY formula.

I expected the result to be 1 but instead it returned #N/A.

What is wrong?

What I am trying to match is the condition a in Column E and if the date is less than or equal to 3 workdays after the date in Column D.

Thanks


EDIT SORTED:

Should be:

=MATCH(1,(B1=E1:E4)*(A1<=WORKDAY(D1:D4+0,3+0)),0)

 

[Gerald Higgins]

Well for one thing, are you getting confused with your column references ?
When you posted your data, it appeared that ALL data was in columns A:D, but your formula (and later comments) refer to column E.
It would help us if we were clear on this point.

But apart from that, what are you actually trying to achieve ?

Are you trying to calculate whether the date in col A for item "a" in col B is less than 3 working days after the date in column C that applies to item "a" in column D ?

If YES, then this formula will indicated TRUE if those conditions are met, and FALSE if not (and #N/A if the item in col B is not found in col D)

=A1< WORKDAY(INDEX(C1:C4,MATCH(B1,D1:D4,0)),3)<workday(index(c1:c4,match(b1,d1:d4,0)),3)

</workday(index(c1:c4,match(b1,d1:d4,0)),3)

 

[tiredofit]

Thanks but I've sorted it out now.

Seems you have to add 0 to the arguments.