CYA30

Junior Member

Posts: 1

Vlookup to return 0 instead of NA

I am hoping someone can help me....

I am currently building out a spreadsheet and have successfully (I hope!) used this formula
=VLOOKUP(MROUND($D$13,2),Sheet2!$A$1:$H$353,2,TRUE ). It's returning the numbers that I need. What I would like though is for it to return a 0 instead of N/A when the information is not available. I am using the results in calculations and really need it to return either a 0 or be blank.

Thank you for your help!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Vlookup then interpolate,return corresponding value, if not, return other value	Wzaman	Excel Worksheet Functions	1	December 14th 10 01:17 AM
VLOOKUP return #N/A	William Beard	Excel Programming	4	January 24th 09 11:01 PM
VLookUp - Does the VLookUp return the exact information?	Cpviv	Excel Worksheet Functions	2	October 28th 08 09:57 AM
VLOOKUP return - #N/A	Tim	Excel Programming	8	February 5th 04 01:10 AM
VBA Syntax for VLOOKUP to return array of return values	Alan Beban[_3_]	Excel Programming	7	August 5th 03 11:41 AM

All times are GMT +1. The time now is 10:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us