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
|