Forum Discussion
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 che...
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.