View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default to Don: display last entry to cell automatically

Hi,

It shouldn't do if you copy it exactly as it appears in your post.

Mike

"mike CBA" wrote:

the formula =lookup(999999,b:b) resulted in #NAME?