merge formula

i want to make a merge of 2 formulas in one cell .. i attached a sheet as an example of what i need to do

Unless I am misunderstanding your request, it looks like excel has done what you would like it to do. Just stretch out the column containing the formula, and it will all fit in one cell. Your other option is to highlight F8 and G8, right click, go to the alignment tab, and click on merge cells.

Let me know if this helps.

Originally Posted by BigBas

Unless I am misunderstanding your request, it looks like excel has done what you would like it to do. Just stretch out the column containing the formula, and it will all fit in one cell. Your other option is to highlight F8 and G8, right click, go to the alignment tab, and click on merge cells.

Let me know if this helps.

sorry but if i tried to merge it , then i must delete one of the formulas ,
and what i try to do is to make it looks like one setntences , if u take a look at the ROW #3 u will find there is a big space between the the word in column F and the column G
so i try to make it as i refered under the table ... but who to do it in one step ??

Again, not sure if I understand you, but you can use this formula in cell F2, and fill down:

=(IF(ISERROR(VLOOKUP(A2&B2,PROJECTS!$A$2:$E$500,5,FALSE)),"-",VLOOKUP(A2&B2,PROJECTS!$A$2:$E$500,5,FALSE)))&(IF(ISERROR(VLOOKUP(C2&D2&E2,DATA!$A$1:$E$45,5,FALSE)),"-",VLOOKUP(C2&D2&E2,DATA!$A$1:$E$45,5,FALSE)))

That will automatically combine the two statements into one statement

Originally Posted by BigBas

Again, not sure if I understand you, but you can use this formula in cell F2, and fill down:

=(IF(ISERROR(VLOOKUP(A2&B2,PROJECTS!$A$2:$E$500,5,FALSE)),"-",VLOOKUP(A2&B2,PROJECTS!$A$2:$E$500,5,FALSE)))&(IF(ISERROR(VLOOKUP(C2&D2&E2,DATA!$A$1:$E$45,5,FALSE)),"-",VLOOKUP(C2&D2&E2,DATA!$A$1:$E$45,5,FALSE)))

That will automatically combine the two statements into one statement

thank you it's working and that's is what i need

thanks again

Glad to help.