Try using if(iserror(vlookup(Value,Table,column,0)),"your
response",(vlookup(Value,Table,column,0)))

Hope that helps

"zeilski" wrote:

Is this still true for Excel 2007? Because I tried the top one, and it still
left 0's in the column.

"T. Valko" wrote:

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"B. Franklin Saunders" wrote
in message ...
It worked. Thank you!!

"T. Valko" wrote:

Try one of these:

Returns a blank:

=IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....))

Returns a 0:

=IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....))

--
Biff
Microsoft Excel MVP


"B. Franklin Saunders" <B. Franklin
wrote in message
...
I'm using vlookup in excel to pull select data from a worksheet. The
problem
is that the value I'm seeking isn't always in the table array. So, I
get
a
#n/a error. The #n/a then prevents me from summing the data that I'm
collecting using the vlookup. How do I make the #n/a go away or equal
zero
so I can sum the data?