You are here: HomeExcelTutorials

# VLOOKUP Formula to return 0 instead of #N/A

## VLOOKUP Formula to return 0 instead of #N/A

Price: FREE

the following formula =VLOOKUP(B16,'Number of Accruals'!A2:F1014,6,FALSE)
returns '#N/A' when the lookup value does not exist, I would like to be able to return a '0' in this case.

Visit publisher's web-site: VLOOKUP Formula to return 0 instead of #N/A

Category and Tags: ExcelTutorials :

## Related Tutorials

### Vlookup return error if cell contain formula

Free: Yes
Tags: Excel ›

my vlookup return error when the table array contain formula,ex:
=VLOOKUP(G2,plan!F:J,5,0). cells F:J contain value return by formula.

### How to return a blank with VLOOKUP

Free: Yes
Tags: Excel ›

when doing a VLOOKUP to return values, I would like the blank cells to return as blank (ie. not have a 0 or N/A filled in, just leave a blank). Please help me fix this formula to return the numbers when there are numbers, and nothing if it is blank. Thank you!
=VLOOKUP(C62,'Lookup'!\$B\$6:\$F\$200,3,0)

### Combining VLOOKUP and IF formula to return a \$ value

Free: Yes
Tags: Excel ›

I have this spreadsheet (attached) column c has a Vlookup formula, and D has an IF formula. How can I join the 2 formula's and still return a dollar value?
I have had the C column come back as a \$ value, but then I struggle to join the IF formula to it. I have a formula that adds the 2 columns together, but im wondering if it is possible for column C to have both of the formula's instead of having 3 different columns to produce the result im after?

### Vlookup return Zero if not there

Free: Yes
Tags: Excel ›

I'm doing a vlookup. If the value I"m looking up is not in the array I've set up I want the formula to return a zero.
Here's the formula: =VLOOKUP(C11,'Payment Matrix'!B128:C134,2,TRUE)

### Vlookup to return unique value

Free: Yes
Tags: Excel ›

I'm looking for a VLookup (or formula) that will look through a list of multiple names and return only a unique name.

## Related Applications & Scripts

### Bookmark Popup

Free: No

Do you want your visitors to return to your site and share your message with friends, family, and coworkers? The easiest way to keep visitors coming back is to encourage them to bookmark your site. By bookmarking a website visitors are reminding themselves that they want to return to your site.
Not only will this increase your sites basic but it also increases your sites popularity. Many web site owners do not realize that a sites true popularity is based upon its repeat visitors. The number of repeat visitors shows that your site is so appealing that it not only attracts many unique visitors, but it also encourages these visitors to return time and time again. If you are someone that is selling a product the majority of sales and conversions are made because of return visitors. It often takes many visitors more than one visit to a web site to decide whether or not they are going to make a purchase. I myself will often visit an online store several times before committing myself to an actual purchase.

### Range Search by location

Free: No
Tags: PHP › Excel Geolocation Web Search

This script return all cities in selected range and address, is useful when searching nearest city or point of interest like shop. Simply pass a location and the search range and it will return cities and distance. The script use Yahoo API for geocoding location, the pack include also sql table for local database, you must insert geolocation data into it.

### PHP Map + Location Plugin

Free: No
Tags: PHP › Excel Geolocation

This is a collection of location based functions that can get a users location based on their ip address using the IPInfoDB api, return advanced details on a specific location with the Yahoo PlaceFinder api, or dynamically create maps (as images or with javascript) using the Google Maps api.
This function interacts with the IPInfoDB.com API to get a users location based on their IP address. It can return city, state, country, latitude & longitude and is accurate within a 25 mile radius. This function accepts an IP Address and returns an array of location based values.

### Safely access user input like GET and POST variables

Free: No
Tags: PHP › Excel Classes

Use this PHP Class to safely access user input like GET and POST variables. Set it and forget it! This class automatically sanitizes your data in various ways. Current options include strict, html, mysql, both (html and mysql), or none.
Each sanitizing level handles data a little bit differently. strict will return input with only alphanumeric characters. html encodes all html-entites. mysql escapes all special mysql characters (no mysql connection required). both runs the html sanitizing and then the mysql. none will give you the data as it is.
Optional maxlength parameters included! Before you sanitize a string, you can define the max length (for strings) or max value (for numbers). Strings will be cut off at the maxlength before it is sanitized, and numbers wont be allowed past that value.
Arrays are supported! This class will recursively sanitize any array it runs into. That means you can return the entire \$_POST variable with each and every value sanitized the way you want it.
Force data types! You can force any value you retrieve to be an int, float, or boolean.

### Automated joke site script

Free: No
Tags: PHP › Excel Entertainment