View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tweacle
 
Posts: n/a
Default How do I cure a "V look up problem


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.


--
tweacle