Forum Discussion

Alex Butt's avatar
Alex Butt
Copper Contributor
Jan 21, 2018

Combining Excel Formulas

i,

 

I would like to draw the following data from Sheet 1 based on if cell (D5) equals 1:

Firstname (F5) and surname (E5) and input in Sheet 2 (A16).

 

Once completed I would like it to check all of Column D and then input any additional True into the A column in Sheet 2.

 

I have used the following formula but it doesn't move down the column 

=IF('Sheet1'!D5=1,TRANSPOSE('Sheet1!F5&" "&'Sheet1!E5),"")

 

Any help would be much appreciated

 

Excel Formula
Formulas & Functions
  • David Hager's avatar
    David Hager
    Copper Contributor
    Jan 21, 2018

    I do not believe you can combine multiple columns of data with the "&" function inside an array function. I suggest you make a column with    =Sheet1!F5&" "&Sheet1!G5.

     

    I do not see the "tell tell" braces for the transpose function. I don't know how you could do a "CTRL+SHIFT+ENTER" that you need to do to make this function work and have ampersands in the formula.

     

Resources