Thread: Vlookup Error
View Single Post
  #1   Report Post  
mick.smith1964
 
Posts: n/a
Default Vlookup Error

Hi

I have alot of Vlookup functions in a worksheet. Some return values, others
do not which results in #N/A in the cell.

Is there a way to avoid #N/A being returned. All I want is either a positive
value or an empty cell.

Thanks for any suggestions