Previous Topic Next Topic

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 responses

Answer 1 / 2
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
AugustaD
Jun 20, 2016 at 02:48 AM
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
Answer 2 / 2
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response