if formula?

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

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
 
Hi,

Try this array formula

=INDEX(C1:C3,MATCH(A1,LEFT(B1:B3,1)+0,0))

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike
 
Back
Top