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


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)," ")





You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join CCI Pro
CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries