View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Kline[_2_] Don Kline[_2_] is offline
external usenet poster
 
Posts: 28
Default Finding the cell with a specified string

I am importing worksheets into a workbook which then need to parse. I then
need to find the cell on a different worksheet which has the string
"value_GuaranteedCashvalue". I don't know what column or row it will end up
in upon import.

If I know the column, I can find the row by using the Match function. What I
can't seem to get is finding the number of the column.