I need a formula that will lookup two references and return a summation from a third column. I am getting stumped trying to figure out how to write it, but if it was just written, it would look like this.
(As written in cell B3 of Sheet 1)Lookup cell A3 AND cell B2 on Sheet 2, if you find both on the same row, return the summation of column B for all matches into cell B3. If you cannot find matches to both, "null". --Then the same formula would be written for every cell across and down on this sheet.