Hi all,

First of all, I'm new here but your forum has helped me a lot in the past.
Now, I'm encountering the following problem and am not able to solve it myself.

I have created a sales pipeline list in a workbook. One of the sheets ("Contacted potentials") has the following setup:

A---------------------B---------------C----------------D
Company name--------Location--------Probability--------Total company sales

Rows 1, 2 and 3 have other information. The actual list starts at the 4th row.

In another worksheet ("Overview"), I want to create a list of companies that have agreed on working with us (displayed by a probability of 100%).
This should preferably be done in column A. Furthermore, column B should list the total company sales for that specific company.
I have tried this myself using INDEX and MATCH formulas, by using the following formula:

=INDEX('Contacted potentials'!$A$4:$A$1000,MATCH(100%,'Contacted potentials'!$C$4:$C$1000,0))

But this only displays one of the companies, not all those which have a probability of 100%.
I am hoping you can help me out on this one.

Thanks in advance,

Rob


Ps. it is possible to automatically update this list (by pressing F9) when a company's status changes to 100%?