ExcelBanter - how to get rid of #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to get rid of #N/A (https://www.excelbanter.com/excel-worksheet-functions/167636-how-get-rid-n.html)

Mahesh

how to get rid of #N/A

when ever we are using some lookup function, in case if there is no
corresponding value, we get #N/A

so let me know how to get rid of it

Mike H

how to get rid of #N/A

Maybe:-

=IF(ISNA(VLOOKUP(A1,B1:C3,2,FALSE)),"Not Found",VLOOKUP(A1,B1:C3,2,FALSE))

Mike

"Mahesh" wrote:

when ever we are using some lookup function, in case if there is no
corresponding value, we get #N/A

so let me know how to get rid of it

Gord Dibben

how to get rid of #N/A

Example formula to trap for #N/A

=IF(ISNA(VLOOKUP(G2,$C$1:$F$31,2,FALSE)),"",VLOOKU P(G2,$C$1:$F$31,2,FALSE))

Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 03:00:02 -0800, Mahesh
wrote:

when ever we are using some lookup function, in case if there is no
corresponding value, we get #N/A

so let me know how to get rid of it

All times are GMT +1. The time now is 11:07 AM.