#N/A

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

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.
 
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)
 
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!
==============================================

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.
 
Hello Norman from Steved

I'm getting an error.

It is highlighting ""

Can you assist me as to what my problem is please.

Thankyou.
 
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.
 
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
(e-mail address removed)



.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top