VLOOKUP #N/A when no criteria entered

nroy

Board Regular
Joined
Oct 16, 2007
Messages
121
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
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top