Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
some cells display formulas, some display values | Excel Discussion (Misc queries) | |||
How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
Display every 3rd category name but still display latest month | Charts and Charting in Excel | |||
Can I display an Excel chart as my screensaver display? | Charts and Charting in Excel | |||
Numbers display as decimal, i.e. enter 123 display 1.23 | Setting up and Configuration of Excel |