Thankyou RD


-----Original Message-----
You had a few redundant commas in there, so see how this
works:

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all
may benefit!
==============================================

"Steved" wrote in
message
...
Hello from Steved

The below formula gives me #N/A if there is no value in
the cell. Could you please tell how I can make the cell
blank, until a value is added.

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

Thankyou.

.