Hi,
Can anyone help with this VLOOKUP problem?
Column A is where I will enter my lookup criteria - a 5-digit code
Column B contains my lookup formula - returning a monitory value when the code is entered. The formula is =VLOOKUP(A2,data2010,2,FALSE)
Cells B2 - B6 contain the lookup formula but show #N/A when no code has been entered in cells A2 - A6. I would like the cell to appear blank when no code has been entered as I will not always need to uses all rows.
Cell B7 is is my total formula =SUM(B2:B6) This returns a #N/A if there are any #N/A errors in column B.
I would like to stop the #N/A errors appearing in column B and for the total amount to show in cell B7.
I hope this makes sense!
Many thanks,
Nicola
Can anyone help with this VLOOKUP problem?
Column A is where I will enter my lookup criteria - a 5-digit code
Column B contains my lookup formula - returning a monitory value when the code is entered. The formula is =VLOOKUP(A2,data2010,2,FALSE)
Cells B2 - B6 contain the lookup formula but show #N/A when no code has been entered in cells A2 - A6. I would like the cell to appear blank when no code has been entered as I will not always need to uses all rows.
Cell B7 is is my total formula =SUM(B2:B6) This returns a #N/A if there are any #N/A errors in column B.
I would like to stop the #N/A errors appearing in column B and for the total amount to show in cell B7.
I hope this makes sense!
Many thanks,
Nicola