In article <1120246591.296457.157290@g47g2000cwa.googlegroups.com>,
"Harlan Grove" <hrlngrv@aol.com> wrote:

> Domenic wrote...
> ...
> >Or, you can eliminate the ISNUMBER function...
> >
> >=IF(COUNTIF(INDEX($A$2:$D$6000,0,MATCH(F1,$A$1:$D$1,0)),F2)>0,"Y","N")
>
> And what does this return when the area code in F1 doesn't appear in
> A1:D1?

Ahhh yes! Thanks Harlan!