Substitution

C

Catalin

Hi to all and one.

I have the following problem: I find the row number by
some formulas and I know the column. Is any "macro
substitution" to use them for receiveing the data for
that cell. To be more exactly, in the next formula:

{=IF(E2="", "", INDEX(DailySheet!I:I,MAX((DailySheet!
A1:A5000=E2)*ROW(INDIRECT("1:5000"))))}

I want to substract the row reference from "A1:A5000" and
from "1:5000" reference.

Regards,
Catalin.
 
Top