ThunderPlane
New Member
 Joined
 Apr 7, 2021
 Messages
 13
 Office Version

 2016
 Platform

 Windows
 Mobile
 Web
I need to create a MAX (with IF) formula similar to this:
=MAX(IF(C3:C12=A3,G3:G12))
But I want to keep the cell ranges dynamic and taken from another cell.
For example, cell B3 has the value "C7:C10" (this is in turn achieved by a VLOOKUP formula, and is not a text value)
Now, in the above formula I want "C3:C12" to be replaced with the contents I have in cell B3, i.e. "C7:C10", something like this:
=MAX(IF(Contents in B3=A3,G3:G100))
So finally my formula should be:
=MAX(IF(C7:C10=A3,G3:G12))
Please help me out with this. Thank you in advance for you help.
Regards,
TP.
PS: Below is a sample of the worksheet I am creating
=MAX(IF(C3:C12=A3,G3:G12))
But I want to keep the cell ranges dynamic and taken from another cell.
For example, cell B3 has the value "C7:C10" (this is in turn achieved by a VLOOKUP formula, and is not a text value)
Now, in the above formula I want "C3:C12" to be replaced with the contents I have in cell B3, i.e. "C7:C10", something like this:
=MAX(IF(Contents in B3=A3,G3:G100))
So finally my formula should be:
=MAX(IF(C7:C10=A3,G3:G12))
Please help me out with this. Thank you in advance for you help.
Regards,
TP.
PS: Below is a sample of the worksheet I am creating
Reference  Range  Name  Date  Time  Open  High  Low 
B  C7:C10  A  03012020  09:45:59  23  23  23 
A  03012020  09:45:59  1535  1540  1535  
A  03012020  09:45:59  0.1  0.1  0.1  
B  03012020  11:45:59  0.8  0.8  0.8  
B  03012020  11:45:59  1122  1122  1080.1  
B  03012020  13:45:59  1019.3  1032.1  1019.3  
B  03012020  09:45:59  0.9  0.9  0.9  
C  03012020  10:45:59  0.9  0.9  0.9  
C  03012020  11:45:59  1.1  1.1  1.1  
C  03012020  13:45:59  1.3  1.3  1.25  