Please help me if you can:
In one work sheet "DATA"! I have a list of number 1,5,8,134,54,23 These numbers are in A1-A6
In Another worksheet within the workbook "SUMMARY"! I have multiple cells in Column D pointing to these cells:
ie D1-D6 the cells are ="DATA"!A1 - "DATA"!A6
in column L in "SUMMARY" I am trying to find the row of the data in column D of "DATA"! that is being reference by the cells in Column C and write this new formula in such a way that I can use the fill function in excel to drag the equation:
ie Within Cell L1 I want to write an equation "Row(" where the formula refers to C1, but knows to give me the row number of the values in Column D of the "DATA" sheet.
thank you for your help
Bookmarks