View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken King Ken King is offline
external usenet poster
 
Posts: 15
Default Lookup function when 'lookup_value' does not always exists

I am using the LOOKUP funtion for an array. Of my 300+ values I know that
about 20 'lookup_value'(s) don't exists in the array, but I don't want it to
find the next closest value. How can I test my array to see if the
'lookup_value' exists?
Thanks,
Ken