Possibly a Max Formula

[rajkenya1]

Hi


I need help on a formula which would in the attached spreadsheet in cell D23 pick the maximum value from range G50:DC50 based on the cell D22(year 1) and so on from the range G13:DC13.


Please find the attached when I have manually tried to insert it.


Please help.


Thanks


Raj

 

[jayalaxmi]

Hi


I need help on a formula which would in the attached spreadsheet in cell D23 pick the maximum value from range G50:DC50 based on the cell D22(year 1) and so on from the range G13:DC13.


Please find the attached when I have manually tried to insert it.


Please help.


Thanks


Raj

hey raj I need a bit more clarifications on ur query??? based on 2 ranges and 1 criteria u need the output??

 

[Tiago MF]

Hi

On D23 put:
=MAX(IF($G$13:$DC$13=D22,$G$50:$DC$50,0))

And confirm the formula by pressing Ctrl+Shift+Enter

KR,

 

[rajkenya1]

Thank you Very much Tiago This works perfect.

Thanks also Jayalaxmi for trying.

Cheers