View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron
 
Posts: n/a
Default Search array and return element No

I want to seach an array and return the element no of the first cell
that is empty. Vlookup does not work as it returns the value as opposed
to the element no.

I want to do something like Find except accross an array rather than
within a string.

Any ideas

Thanks