Thankyou Norman

-----Original Message-----
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



.



.