vlookup and #n/a

  1. V

    VLOOKUP to return 0 instead of N/A

    This is my formula: =VLOOKUP($B17,'BY2015'!$A$1:$N$121,2,FALSE) In some cells it has returned #N/A where it cannot locate a value-I need a 0 returned instead of #N/A Can someone please help me with this? Let me know what additional information I need to provide. Thanks for your time and...
  2. E

    Vlookup VBA error if value not found

    Hi, I am new to the forum and also to creating macros in excel with vba. I have a similar problem to many people around this forum, but the answers i read didn't seem to help my case. The thing is that i have two sheets which have tens of thousand lines each. In one of them I have the...
    • evaluna
    • Thread
    • crashes macro excel vba & excel vlookup and #n/a
    • Replies: 7
    • Forum: Excel Questions
  3. G

    VLOOKUP Question - Number Stored As Text Error Not Returning Values

    Hello, When I run my VLOOKUP to match values from one sheet to another, the Table_array consists of data where the values are stored as text. The values on the Table_array can be numbers only or alphanumeric. Some of the numbers have leading zeros as well. When I run the VLOOKUP, the formula...
  4. B

    VLOOKUP and #N/A

    I am currently working on a worksheet for our Construction Department. The worksheet has a Plan Quantity column, a $ per Unit column, and a Final Quantity column. These 3 columns are the cells where the data gets entered. The next column, Difference, calculates the % difference between the Plan...

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