Forum Discussion

Caesarus7's avatar
Caesarus7
Copper Contributor
Jan 09, 2019
Solved

Index and match 2 values to then create a percentage

Hi all, I am looking to make a table of stock market index performance for various time ranges. I have tried using the index and match function but not sure how to incorporate that into a wider...
excel
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Jan 09, 2019
    Hi

    Try this

    =1- ( INDEX('Index Raw Data'!C5:C60,MATCH(I3,'Index Raw Data'!B5:B60,0)) / INDEX('Index Raw Data'!C4:C59,MATCH(I2,'Index Raw Data'!B4:B59,0)) )
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jan 09, 2019
Hi

Try this

=1- ( INDEX('Index Raw Data'!C5:C60,MATCH(I3,'Index Raw Data'!B5:B60,0)) / INDEX('Index Raw Data'!C4:C59,MATCH(I2,'Index Raw Data'!B4:B59,0)) )
  • Caesarus7's avatar
    Caesarus7
    Copper Contributor
    Jan 10, 2019

    Thank you so much! this worked a treat!

     

    Cheers

    Joel 

Resources