View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dax Arroway Dax Arroway is offline
external usenet poster
 
Posts: 70
Default Don't Display #N/A

I have a formula that pulls info from another page. The formula is:

{=INDEX('Patient Count'!$J2:$J5000,MATCH(1,('Patient
Count'!$C$2:$C$5000=A2)*('Patient Count'!$N$2:$N$5000=""),0))}

which, if there's no information entered in the indicated cell of the
referring sheet, a #N/A is displayed. I'd like to the cell to remain blank.

What is the code I should add to the above formulat to NOT display the #N/A
in the cell?

Thank you very much in advance!
Dax
--
I would give my left hand to be ambidextrous!