Forum Discussion
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...
- 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)) )
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)) )
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)) )
Thank you so much! this worked a treat!
Cheers
Joel