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

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.

by mu'awiah al'amad , Project Managment , Saudi Telecommunication Company (STC)

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

Upvote (2)

Downvote Reply () Report

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)

Upvote (1)

Downvote Reply () Report

The short cut key Ctrl + R is used in Excel to
Top Answer: Answer is -------option C) See More

Answers (5)
Fix Synchronizing Errors using InQuit OST Recovery Tool?
Top Answer: ATS OST to PST Converter is specially designed tool that can help the MS Outlook user when they get stuck ... See More

Answers (8)
How to Remove Errors and Repair Drone Videos?
Top Answer: Well, I have only used ImageRevolver, they are a video production studio that offers professional service ... See More

Answers (1)
88% of your spreadsheets contain errors! how do you manage?
Top Answer: <p>Simple re write the formullas. No point in correcting88% errors. </p> <p> </p> ... See More

Answers (12)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help