I have a worksheet where I use the combination of the index & Match function
to retrieve data from other sheets in a workbook. The retrieved data is in
multiple rows and mltiple columns. Each column has autofilter enabled so I
can quickly sort for the rows with specific data. With Office 2003 the
autofilter also allows for quick sortation of the data. My problem is that
within the index match formula the match lookup value does not update row
number as the filter sorting is applied. In other words, if the original
match formula was referencing a lookup value in row 48 and that row changed
as a result of the sort to row 100 the formula still is referencing row 48
instead of the new row 100.

Does anyone know of a work arround? Is there a "trick" I am unaware of?
Thanks for any assistance.