View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Returning a blank cell rather then #N/A (Lookup)

If you just want to copy the contents of cell A1 into cell B1, in cell
B1 you can use
=A1

This will avoid the whole N/A problem.