yogi_Extract Row Numbers Where Entries In Column A Begin With A Specified String

                                          Google Spreadsheet   Post  #925

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 12, 2012
user 2[H]ard said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/5Xw0ccPSM0E)
Return row numbers on a separate spreadsheet from partial string match

Windows 7 on Chrom

So I need to be able to return the row number of multiple partial string matches. Example is below. I need to be able to return so A1=2, A2=3,A3=5 based off a partial string match of "DW". Is this possible? The reason I want to do this is so I can use the row number in an importrange function and return all the other values I need in each row off a Master sheet so I can give viewing permissions to the sub spreadsheets but update on the Master sheet.

Row  Column A

1       LB-100

2       DW-102

3       DW-30

4       BJ-500

5       DW-50

Thanks for any help.

-------------------------------------------------------------------------------------------

in the following I have presented a solution to a bit more generalized problem -- I have extracted the row numbers in column C of the same sheet, for extracting the row numbers in another sheet, the formula in cell C1 can be moved to cell A1 of the other sheet