Nested MATCH/IF statements

Question

What would be the formula to look up data and return a value if a condition is met?  Example:

Data:

1234  8/1/2010      $100

1234   8/18/2010    $200

1234    8/19/2010     $400

1234     RESULT        $700

9990     8/18/2010       $50

9990      RESULT         $50

Solution Needed:  Need to search the data for the value "1234" in Column A WHEN Column B contains "Result", and return the value in Column C of the "Result" row.  I will then need to use this to serach for the next value in column A that has a "result" in column B and return value in column C.    Otherwise, I need to pull out all values for the Results and list those results by the value in column A.  It is a big table of data.

How best should I do this?

Answer 1

I would be very inclined to use a pivot table for that...

http://peltiertech.com/Excel/Pivots/pivotstart.htm

When I pivoted your data I ended up with this...

Date	Result
Sum of Amount
Location	Total
1234	700
9990	50
Grand Total	750

It requires no formulas or anything else as such.

---

If this post answers your question, please mark it as the Answer... Jim Thomlinson

Answer 2

Or how about just filtering the information on column B and only show "Result"?

Answer 3

Why not just sort on column "B" and a secondary sort of column "A" - am I missing something?