Macro substitution

  • Thread starter Thread starter Catalin
  • Start date Start date
C

Catalin

Hi to all and one.

I have the following problem: I can 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.
 
I have the following problem: I can 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.
Click to expand...

Unclear, but I'm going to guess you mean you want the cell in DailySheet column
I that corresponds to the (topmost) maximum value in DailySheet column A. Try

=IF(E2="","",VLOOKUP(MAX(DailySheet!A1:A5000),DailySheet!A1:I5000,9,0))
 
Back
Top