View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kim Greenlaw
 
Posts: n/a
Default can lookup return err if no match found

If lookup doesn't find a match in the first column, can I get it to return an
"ERR" or "0", something that would let me know there was no match? Right now
it returns the value in the second column of the closest value.