Hello everybody,
I have a sheet containing historical exchange rates for AUDJPY (2 columns, Date and Price). I also have another sheet containing hypothetical AUDJPY trades (4 columns, Start Date, End Date, Start Price and End Price). What I would like to do is find the maximum value of a range as defined by the Start/End dates for each trade. I tried using the following but it only takes the Start/End prices and finds the MAX of the two, ignoring all values in between:
=MAX(VLOOKUP(A2,'Historical Data'!A4:O4385,2), VLOOKUP(AUDJPY!B2,'Historical Data'!A4:O4385,2))
Does anyone have an idea of how to solve this?
Many thanks!
