Excel Formula

Closed
augustaD
Posts
1
Registration date
Saturday June 18, 2016
Status
Member
Last seen
June 18, 2016
- Jun 18, 2016 at 02:22 PM
fdibbins
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
- Jun 22, 2016 at 01:39 AM
Hello everybody!
That seems so simple but I can't do it :(

I would like to know the formula for this:

If any text is found in cells T23 U23 V23 or Z23 this same text should be copied to this cell where the formula goes (C23).

This text could be any of these four: Apple/Pears/Peaches/Grapes

Thank you so much

2 replies

fdibbins
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
Jun 19, 2016 at 11:47 PM
could all 4 cells contain text? If so, which 1 do you want returned?
0
Thank you very much for willing to help.
No, out of the 4 given cells only one will have an answer. The other three will automatically be empty.
0
fdibbins
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
Jun 22, 2016 at 01:39 AM
sorry for the delay in replying.
What would W:Y contain?

If nothing, then try this...
=INDEX(T23:Z23,MATCH(TRUE,INDEX((T23:Z23<>0),0),0))
0