How not to show #N/A when using vlookup formula

[inthestands]

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]

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

[Niek Otten]

=IF(ISNA(YourFormula),"",YourFormula)

--
Kind regards,

Niek Otten

"inthestands" <[email protected]> wrote in message
news:[email protected]...
>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