An curved arrow pointing right. Once you have mastered VLOOKUP in Excel it's time to move on to INDEX/MATCH. This formula combination gives the same results but without the problems of VLOOKUP.

Use the CORREL function in Excel to calculate this value ... In reality, stock prices and index values can have asymmetrical distributions. They can stay unusually high or low for long periods.