Hi Everyone,
Need a little help in trying to get the correct formula for this data-set. currently I have =LOOKUP(2,1/(Sheet2!$A$3:$A$250=$A2)/(Sheet2!$B$3:$E$250=B$2)) though it is not the correct total I am looking for..
So.. Sheet two is a weekly total of issues each company has ( e.g. B3 to E3 )and I would like the total for those weeks (the full month e.g. B3+C3+D3+E3 = Total) to show up on Sheet 1 B2 based on the company name. and repeat for the each month after that.
Thankyou!
Bookmarks