I have 3 worksheets in one workbook (sheet 1=legend, sheet 2=estimate, sheet 3=distribution). Sheet 1 is the legend that sheet 2 pulls from. Cells B20:B30 (sheet 2) have this formula (this particular formula came from cell B28, hence the reference to cell A28)
=INDEX('Sheet1'!$B$2:Sheet1'!$B$43,A28)
I need my formula (on sheet 3) to say: If cells B20:B30 (sheet 2) says pull from B10 (sheet 1) then multiply C_ (sheet 2) times C18 (sheet 2).
NOTE: The underscore being the adjecent cell to whichever cell pulled from sheet 1.... ie. if B22 then C22 or if B28 then C28
Bookmarks