Excel

This query is : Resolved

Anita Kulkarni (Querist)
Follow

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.

Nikhil Kaushik

Nikhil Kaushik (Expert)
Follow

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

CA CS Jainam Shah

CA CS Jainam Shah (Expert)
Follow

29 December 2015 Use combine formula of IFERROR & VLOOKUP.

Go to following Link:

https://exceljet.net/formula/vlookup-without-na-error

Message likes : 2 times

Hemang Doshi

Hemang Doshi (Expert)
Follow

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