formula error

K

kevcar40

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
 
D

Don Guillett

Look in the help index for ISNA
Do you have a worksheet_open event macro. If so, trap the error there
 

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

Similar Threads

summarizing data from various workbooks 4
MS Project Import Error Row 1 Column 5 2
Copy addition formula of non-consecutive horizontal cells 2
Need some PWA help 0
Excel does not accept text format! 0
Help with Sumproduct searching cell contents 2
Validation list with non blanks from different column 3
Need simple formula to find one string in another 4

Top