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



.