Hello everybody! Hope all are well.
I need some help in filling data in a particular table. I have tried multiple times to get the right formula, tried to seek help from youtube videos but none of it helped me get through.
In the worksheet "Part1" I want to write a formula that uses indirect combined with index/offset/address function in cell J23 that can be dragged across and down J23:M25 to return the exchange rate for the desired currency (J20), year (column I) and month (row 22), and that will update when a new currency is chosen at J20. The years and months needed will change depending on what currency is selected.
The data has to be filled in "Part1" from the 5 worksheets namely, "2012","2013","2014","2015","2016".
I have attached the file for the same.
Any help would be appreciated.
Thankyou,
Ria
I need some help in filling data in a particular table. I have tried multiple times to get the right formula, tried to seek help from youtube videos but none of it helped me get through.
In the worksheet "Part1" I want to write a formula that uses indirect combined with index/offset/address function in cell J23 that can be dragged across and down J23:M25 to return the exchange rate for the desired currency (J20), year (column I) and month (row 22), and that will update when a new currency is chosen at J20. The years and months needed will change depending on what currency is selected.
The data has to be filled in "Part1" from the 5 worksheets namely, "2012","2013","2014","2015","2016".
I have attached the file for the same.
Any help would be appreciated.
Thankyou,
Ria