Excel
This query is : Resolved
29 December 2015
hello,
can anyone tell me how to remove the #N/A error in a spreadsheet while using the vlookup function.,or what care needs to be taken to avoid such errors while using lookup function.
29 December 2015
try using isna function...it woill something like this =IF(ISNA(VLOOKUP(AW506,AW$552:AZ$732,3,FALSE)),0,ROUND((VLOOKUP(AW506,AW$552:AZ$732,3,FALSE)),0))
29 December 2015
Use combine formula of IFERROR & VLOOKUP.
Go to following Link:
https://exceljet.net/formula/vlookup-without-na-error
Go to following Link:
https://exceljet.net/formula/vlookup-without-na-error
Message likes :
2 times
02 January 2016
Hi Anita
If you want to return a blank with any error from the VLOOKUP you can use IFERROR function if you have Excel 2007 or later, i.e.
=IFERROR(VLOOKUP(A7,A6:B11,2,0)," ")
If you want to return a blank with any error from the VLOOKUP you can use IFERROR function if you have Excel 2007 or later, i.e.
=IFERROR(VLOOKUP(A7,A6:B11,2,0)," ")
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- CAPITAL GAIN BASE ON NOTIFICATION
- Unregistered suppliers utility
- ITDS U/S.194T of Firm
- NRI starting business in India
- Difference between Date of Payment and Date of Deduction?
- Journal entry of busniess expenses
- GST not cancelled by tenant
- FORM 141 SDV query
- URGENT-Eligible leaves being shown as 24 days for 3 years Articleship instead of 156 days in 108
- Cash balance limit and property purchases limit
- Taxable or Tax exempt
- How to pay remaining amount of TDS after due date?
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
