Thread: #N/A
View Single Post
  #2  
Old July 9th, 2004, 01:43 AM
Norman Harker
external usenet poster
  
Posts: n/a
Default #N/A
Hi Steved!

=IF(ISNA(INDEX('Audit Team'!$A$1:$C$2000, MATCH(E2:E2001,'Audit
Team'!$A$1:$A$2000,), MATCH("Surname",'Audit Team'!
$A$1:$C$1,)),"",INDEX('Audit Team'!$A$1:$C$2000, MATCH(E2:E2001,'Audit
Team'!$A$1:$A$2000,), MATCH("Surname",'Audit Team'!
$A$1:$C$1,)))

IOW you use a standard construct:

=IF(ISNA(YourFormula),"",YourFormula)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia