Member Avatar for quiptro
quiptro 0 Newbie Poster

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!

  • 1 Contributor
  • 0 Replies
  • 86 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.