If Statement, problem with #N/A

  • Thread starter Thread starter Voodoodan
  • Start date Start date
V

Voodoodan

Hello,

I have the following line:

=IF(D2<12,"",IF(D2<12,"",IF(D2="","",INDEX(ROSTER!$A$1:$C$365,MATCH((B2),ROSTER!$A$1:$A$365,),MATCH(E2,ROSTER!$A$1:$C$1,)))))

This works fine, but if I want to change the 'less than' sign, shown a
the beginning of the line, to a 'more than' sign, then I get #N/
showing.

I should either get a blank cell or what the value is that should b
returned.

Does anyone know the reason for this, please?

Thanks,
Dan
 
Dan,

It is the MATCH statements, one or other is returning #N/A. Previously, I
assume D2 was < 12 so it didn't get that far. Either correct the data, or
put in a test for these matches

=IF(OR(ISNA(MATCH(B2....)),ISNA(MATCH(E2....))),"",...

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top