I’m trying to find a function that:
collects data (a calculation) and a word (that’s allready written in a cell) on one page, and puts those two togheter in one cell on another page.
on page 1 I have in cell A1: 5 in B3: 2 and in A3: thisword
on page 2 I like to get in one cell: A1 * B3 and the word from A3
If someone can help with that, I’m allready very happy
to make it even more complicated, I actually have a long list like that. A1 always stays the same but B4 is different, B5 also, … and the words are different to.
So, on page 2 I think I can figure out how to put them all there(if I get an answer on the first part of the question). But Here is the tricky part (I’m not even sure it is possible), I would like the cell NOT to appear when the value of A1 * Bx doesn’t exists or is zero (sometimes there is nothing in Bx). So actually it filters the words who have no value and doesn’t show them (even not an empty cell)… Is this possible?