I was involved in a discussion on linkedin about vlookup , one of the contributions which I tested simplifies the formula
Instead of
=IF(ISERROR(VLOOKUP(“A”, Table,1,FALSE)),0,VLOOKUP(“A”, table,1,FALSE))
Try
=IFERROR(VLOOKUP(“A”,Table,1, FALSE),0)
You must be logged in to post a comment.
We provide high tech software systems for a mobile workforce that captures and distributes data from handheld devices.
Our software simplifies complex mobile processes, eliminates paper procedures and enables you to easily track and trace stock and sales.
City Enterprise Centre,
Waterford Business Park
Cork Road,
Waterford City.
(051) 391 338
info@handheld.ie
This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies.
OKLearn moreWe may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.
Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.
These cookies are strictly necessary to provide you with services available through our website and to use some of its features.
Because these cookies are strictly necessary to deliver the website, you cannot refuse them without impacting how our site functions. You can block or delete them by changing your browser settings and force blocking all cookies on this website.
We also use different external services like Google Webfonts, Google Maps and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.
Google Webfont Settings:
Google Map Settings:
Vimeo and Youtube video embeds:
Check out the full thread at here