I have a project that I am trying to fully automate. I use a vlookup to return values from another source. The problem that I am having is that I want excel to return a zero when the value is not found. I have attached a sample of my problem. In column B you can see the lookup formula, which works fine, but I am having the problem in column D where I only want to see 0's when my lookup in B returns #N/A. I have tried everything that I can think of. Has anyone ever run into a solution for this? Your assistance would be greatly appreciated!
Thanks!
Kendra
without looking at the formula, if you substitute it below it should work
if(your lookup=#n/a,0,your lookup)
or
if(iserror(your lookup),0,your lookup)
Regards
Dav
Try
or=IF(ISERROR(B32),0,B32)
VBA Noob=IF(ISNA(B32),0,B32)
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Totally awesome!!! It worked perfectly. Thanks to everyone and thanks for the prompt response.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks