Get startedGet started for free

Find dates with minimum and maximum prices

Now that you are more familiar with VLOOKUP(), your next goal is to use this function to find at which dates historical minimum and maximum prices occurred.

However, there is a problem! Remember that for VLOOKUP() to work correctly the lookup value should always be in the first column. The first column of your dataset is represented by the dates, and in this exercise, you want that column to be the target of your search instead of the lookup value.

What do you do then? Just move (or duplicate) the dates column and append it at the right-hand side of the dividend column.

This exercise is part of the course

Financial Analytics in Google Sheets

View Course

Exercise instructions

  • Select the column A by clicking onto the column name.

  • Copy the column A (CTRL + C) and paste it (CTRL + V) in column D.

  • Now that your table has been reshaped, in F4, use the function VLOOKUP() to find the date corresponding to the minimum price.

  • In F6, use the function VLOOKUP() to find the date corresponding to the maximum price.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise