I have 4 different statements of which one needs to be entered into a
cell depending on some conditions, I have worked out the conditions to
produce a true/false response in four cells as seen below

A B
1 FALSE STATEMENT 1
2 FALSE STATEMENT 2
3 FALSE STATEMENT 3
4 TRUE STATEMENT 4

Depending on which cell is true I want the result cell to have a
different statement come up, i.e. If A4 is TRUE then STATEMENT 4 should
be shown in cell B10, if A3 is TRUE then STATEMENT 3 should be shown in
cell B10... the conditions are such that there is only ever one cell
that can be TRUE.

Someone help please :D


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=545038

="STATEMENT " & MATCH(TRUE,A1:A4,0)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"ChrisMattock"
wrote in message
news:ChrisMattock.28b9qz_1148472908.1448@excelforu m-nospam.com...

I have 4 different statements of which one needs to be entered into a
cell depending on some conditions, I have worked out the conditions to
produce a true/false response in four cells as seen below

A B
1 FALSE STATEMENT 1
2 FALSE STATEMENT 2
3 FALSE STATEMENT 3
4 TRUE STATEMENT 4

Depending on which cell is true I want the result cell to have a
different statement come up, i.e. If A4 is TRUE then STATEMENT 4 should
be shown in cell B10, if A3 is TRUE then STATEMENT 3 should be shown in
cell B10... the conditions are such that there is only ever one cell
that can be TRUE.

Someone help please :D


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile:
http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=545038

"ChrisMattock"
skrev i en meddelelse
news:ChrisMattock.28b9qz_1148472908.1448@excelforu m-nospam.com...

I have 4 different statements of which one needs to be entered into a
cell depending on some conditions, I have worked out the conditions to
produce a true/false response in four cells as seen below

A B
1 FALSE STATEMENT 1
2 FALSE STATEMENT 2
3 FALSE STATEMENT 3
4 TRUE STATEMENT 4

Depending on which cell is true I want the result cell to have a
different statement come up, i.e. If A4 is TRUE then STATEMENT 4 should
be shown in cell B10, if A3 is TRUE then STATEMENT 3 should be shown in
cell B10... the conditions are such that there is only ever one cell
that can be TRUE.

Someone help please :D


--
ChrisMattock


Hi Chris

One way:

In B10

=INDEX(B1:B4,MATCH(TRUE,A1:A4,0))

--
Best regards
Leo Heuser

Followup to newsgroup only please.

Hi

=INDEX(B1:B4,MATCH(TRUE,A1:A4,0))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )




"ChrisMattock"
wrote in message
news:ChrisMattock.28b9qz_1148472908.1448@excelforu m-nospam.com...

I have 4 different statements of which one needs to be entered into a
cell depending on some conditions, I have worked out the conditions to
produce a true/false response in four cells as seen below

A B
1 FALSE STATEMENT 1
2 FALSE STATEMENT 2
3 FALSE STATEMENT 3
4 TRUE STATEMENT 4

Depending on which cell is true I want the result cell to have a
different statement come up, i.e. If A4 is TRUE then STATEMENT 4 should
be shown in cell B10, if A3 is TRUE then STATEMENT 3 should be shown in
cell B10... the conditions are such that there is only ever one cell
that can be TRUE.

Someone help please :D


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile:
http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=545038

Thanks all, that's working now.


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=545038

"ChrisMattock"
skrev i en meddelelse
news:ChrisMattock.28bg03_1148481029.8685@excelforu m-nospam.com...

Thanks all, that's working now.


--
ChrisMattock

You´re welcome :-)

Leo