Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula error
Hi
I Have the following formula in cell c3 ="A"&MATCH(A3,B:B,0) c3 is a define name startpoint column a contains the week number 4 column b contains the date 26-jan-12 the peurpose of the formula is to open the workshhet at the current week number problem is when the worksheet open the cell a3 is blank and there returns #N/A this is giving me a run time error how do i stop this formula returning #N/A thanks kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula error
Look in the help index for ISNA
Do you have a worksheet_open event macro. If so, trap the error there On Jan 26, 3:11*am, kevcar40 wrote: Hi I Have the following formula in cell c3 * *="A"&MATCH(A3,B:B,0) c3 is a define name * startpoint column a contains the week number * *4 column b contains the date * * * * * 26-jan-12 the peurpose of the formula is to open the workshhet at the current week number problem is when the worksheet open the cell a3 is blank and there returns #N/A this is giving me a run time error how do i stop this formula returning #N/A thanks kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula returns error; abbreviating the formula | Excel Discussion (Misc queries) | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
formula error | Excel Discussion (Misc queries) | |||
#REF error in formula | Excel Discussion (Misc queries) | |||
Formula error with Mac resulting in '#NAME' error | Excel Programming |