hi
try this.....
=IF(A1=0, C1,IF(A1=1,C2,C3))

Regards
FSt1

"Jim" wrote:

Hello,

In A1 I will have one of the following number: 0, 1, or 2, which represents
the number of clients lost.

In cell B1 I have the text "0 Clients lost"
In Cell B2 I have the text "1 Clients lost"
In Cell B3 I have the text "2 Clients lost"

In C1 I have $800 (which goes with B1)
In C2 I have $300 (which goes with B2)
In C3 I have $0 (which goes with B2)

In D1, I would like to return the value of the above. For example if "0" is
selected in A1, then D1 will return $800.

Thanks for the help.
Jim