First, thanks to anyone who is looking at this for your help
I am trying to write a formula, which I will use the screenshots below to help explain
\1
\1
You can see in the sheet 'total' that I have rows of countries and columns of years. In the sheet 'sheet2' there is a row for each country and year. I need to transfer the values from 'total' to column 'CTERRTTL' in 'sheet2'.
For example, cell C2 of 'sheet2' should result in the value of cell B6 of 'total'; and C8 of 'sheet2' should result in the value of cell H6 of 'total'
Ideally, the formula will be written into sheet2 C2, and dragged down
I have tried experimenting with the match, index, and lookup formulas, but aren't that familiar with them and can't make it work
Thanks in advance for your help!!
Bookmarks