Thread: formula error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kevcar40 kevcar40 is offline
external usenet poster
 
Posts: 78
Default 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