How do I cure a "V look up problem

T

tweacle

I have a V look up function on my spreadsheet and it has one annoying
thing that I hope you can help with.

In all the columns where the look up values are pasted are the symbols

#N/A before I insert numbers


Is there anyway I can set a lookup but not have the #N/A in each column
and when a value is found for the box it just inputs the data I need it
to.
 
K

Kevin Vaughn

You can wrap your formula in an if isna function. Something like:
=IF(ISNA(VLOOKUP( A1, $A$10:$B$20, 2,FALSE)),"",VLOOKUP(A1,
$A$10:$B$20,2,FALSE))
 
Top