I need a formula that will return the value of a cell from another workbook if it meets a certain criteria. For example, if $F$10 is equal to 15, then it would return the contents of $A$10 on that same row of that worksheet. How could the following formula be revised to do just that.
=SUMPRODUCT(--('[Monthly Tally 2010.XLT]Aug'!$F$8:$F$38=15)
=SUMPRODUCT(--('[Monthly Tally 2010.XLT]Aug'!$F$8:$F$38=15)