Thread: Search column - return row found in long text string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JayL JayL is offline
external usenet poster
  
Posts: 20
Default Search column - return row found in long text string
All -
Looking for a way to search column C for a 9 digit number that resides in
cell A1. I would like to return the row number of any matches to cell B1.
I use the =MATCH function which works except some of the cells in column C
contain text greater than 255 characters (which appears to be the functions
limit) and the function errors out.
Any ideas?
Any help is appreciated.

-Jay


Reply With QuoteReply With Quote