Is is possible to look up a vertical value then a horizontal value and show that value - I can then multiply it.
E.g.
Name,2007,2008,2009
Elect,12,13,3
Gas, 33,55,66
Fuel, 10,11212,4343
So it will look up the year and then select one of the values in that row,
If did try the following:
.=C11*INDEX(carbonfactors,MATCH(B11,carbonfactors,0),MATCH(C1,carbonfactors,0))
C11 would be a consumption value, I have over 100 sites and I would like to automate the calculation process as and when new sites or sources are added
See attached
Bookmarks