What formula do I use to search for a particular row for an event and when the criteria is found, calculate items in the column below? Example:
Row 5 contains the sales price of a building ($1,500,000) in a cell between Columns M and X; the calculation needs to find the cell containing $1,500,000 and then calculate the the NOI contained in the Rows 20 - 30 in the same Column as the cell containing $1,500,000.
Solved by I. B. in 25 mins