View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Audit Compliance Man Audit Compliance Man is offline
external usenet poster
 
Posts: 1
Default EXCEL function;find string in entire column & return cell referenc

I need a function to search an entire column on another sheet (K:K) for a
text string that returns the first cell reference (K34) that contains the
string. Then I can use VLOOKUP to get a second value contained in, say, B34