**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have a formula for a series of 4 cells that is pulling information from another area. I now want to copy the text if one of the formulas comes back with a result

Solved by T. H. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
08/07/2018 - 10:42

Hello! Welcome, Thanks for choosing Got It Pro-Excel. How may I help you today?

User
08/07/2018 - 10:43

ok i added formulas in b4-b6

Excelchat Expert
08/07/2018 - 10:43

ok perfect

User
08/07/2018 - 10:43

i am looking to create a formula then copies any test that is in there

Excelchat Expert
08/07/2018 - 10:44

copy?

User
08/07/2018 - 10:44

i dont have my other document but basically those 3 values will either all be blank, or 1 will have text

User
08/07/2018 - 10:44

if there is text in cell B4:b6 then put the text in this cell

Excelchat Expert
08/07/2018 - 10:44

oook,

Excelchat Expert
08/07/2018 - 10:44

I understand

Excelchat Expert
08/07/2018 - 10:45

i will use the cell D5 as example

Excelchat Expert
08/07/2018 - 10:46

I think is that

User
08/07/2018 - 10:48

looks like it

Excelchat Expert
08/07/2018 - 10:48

try the formula please, is that what you want to get?

User
08/07/2018 - 10:48

yup that is exactly what i needed

Excelchat Expert
08/07/2018 - 10:48

awesome!

Excelchat Expert
08/07/2018 - 10:49

Let me explain exactly what I did

User
08/07/2018 - 10:49

i am following the logic

Excelchat Expert
08/07/2018 - 10:49

I just concatenated 3 IF functions

User
08/07/2018 - 10:49

is there any way to pull it as a series

User
08/07/2018 - 10:49

if i have an area looking at 8 cells it starts getting long

Excelchat Expert
08/07/2018 - 10:49

explain please

Excelchat Expert
08/07/2018 - 10:50

oh I understand, no, it must be done manually

User
08/07/2018 - 10:50

if my formulas were to b b1;b100 can i grab all of that at once

User
08/07/2018 - 10:51

i would want something like that but i just cant find a way to make it work

User
08/07/2018 - 10:52

=if(B4:B6<>0,

Excelchat Expert
08/07/2018 - 10:52

I think it must be done manually

Excelchat Expert
08/07/2018 - 10:52

e you need to have a condition for each cell

User
08/07/2018 - 10:52

bummer ok

User
08/07/2018 - 10:53

thank you for your help

Excelchat Expert
08/07/2018 - 10:53

I'm glad I could answer your question today. I kindly invite you to close this session and please give your kind feedback for our service. Please visit Got It Pro again!

Excelchat Expert
08/07/2018 - 10:53

Have a good day

Excelchat Expert
08/07/2018 - 10:56

are you there??

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*