July 9th, 2004, 02:41 AM
|
|
#N/A
Hi Steved!
Try deleting the "" and re-entering them. I find that if I copy and
paste formulas there are occasions when the "" are interpreted wrong /
differently.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
"Steved" wrote in message
...
Hello Norman from Steved
I'm getting an error.
It is highlighting ""
Can you assist me as to what my problem is please.
Thankyou.
-----Original Message-----
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
.
|