Hello All,
I am stuck on a formula for the spreadsheet attached.
On 'sheet 2' I have a drop down menu which selects an item and then calculates figures for that year. Unfortunately I currently have it set to lookup the figures for the 'Thing1'. I need the formula to look at each 'thing' and do the calculations for that. Hopefully the spreadsheet will make sense.
I'm not sure if I need a Vlookup or what.
Bookmarks