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))
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.