Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can one remove #N/A errors when using Vlookup in Excel?

Microsoft Excel
user-image
Question added by Aatif Khan , Manager Compliance & Reconciliation , Kings Real Estate
Date Posted: 2014/08/03
Upvote (1) Views (9) Followers (4) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
mu'awiah al'amad
by mu'awiah al'amad , Project Managment , Saudi Telecommunication Company (STC)

=IF(ISERROR( Your Expression )), "", Your Expression )

Mohammed Idris Qureshi
by Mohammed Idris Qureshi , Business Development Manager-Financing , Arzan Financial Group KPSC (Previously International Finance Company KSCC)

You can also use the following in the new versions of excel.

IFERROR(value, value_if_error)

Write Your Answer
More Questions Like This