ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How not to show #N/A when using vlookup formula (https://www.excelbanter.com/excel-worksheet-functions/59319-how-not-show-n-when-using-vlookup-formula.html)

inthestands

How not to show #N/A when using vlookup formula
 
I have a vlookup formula =vlookup(V3,SHEET1!,$G$3:$J$14520,4,0) which I have
inputed. Many of the responses come back with #N/A. I would like to remove
this. Using IF(V3="","", does not work, becasue there is data there. What
do I need to add to my formula?
--
Thanks in advance,

inthestand

Niek Otten

How not to show #N/A when using vlookup formula
 
=IF(ISNA(YourFormula),"",YourFormula)

--
Kind regards,

Niek Otten

"inthestands" wrote in message
...
I have a vlookup formula =vlookup(V3,SHEET1!,$G$3:$J$14520,4,0) which I
have
inputed. Many of the responses come back with #N/A. I would like to
remove
this. Using IF(V3="","", does not work, becasue there is data there.
What
do I need to add to my formula?
--
Thanks in advance,

inthestand




Nelson

How not to show #N/A when using vlookup formula
 
You have to add an if statement

=if(iserror(vlookup(V3,SHEET1!,$G$3:$J$14520,4,0)) ,"No
Data",vlookup(V3,SHEET1!,$G$3:$J$14520,4,0))

Hope it helps

"inthestands" wrote:

I have a vlookup formula =vlookup(V3,SHEET1!,$G$3:$J$14520,4,0) which I have
inputed. Many of the responses come back with #N/A. I would like to remove
this. Using IF(V3="","", does not work, becasue there is data there. What
do I need to add to my formula?
--
Thanks in advance,

inthestand



All times are GMT +1. The time now is 04:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com