Hello again !
90% solved of the formula.
Please see new updated sheet. Post #16
I have two cells with different formulas in them. I try to merge both formulas in a third cell to show different results. Depends on the case. All solutions found in searches made by me does not fit my case. I can not use pivot table and not concatenated. Just a simple merge both formulas in a third cell if possible.
Case 1 :
Formula:
=IF(ISERROR(MATCH(A3;FOLHA2!C2:C5;0));"";INDEX(FOLHA2!E2:E5;MATCH(A3;FOLHA2!C2:C5;0)))
join to
Formula:
=SE(É.ERRO(CORRESP(A3;Folha2!C2:C5;0));"";ÍNDICE(Folha2!I2:I5;CORRESP(A3;Folha2!C2:C5;0)))
Case 2 :
Formula:
=IF(ISERROR(MATCH(A3;FOLHA2!C2:C5;0));"";INDEX(FOLHA2!G2:G5;MATCH(A3;FOLHA2!C2:C5;0)))
join to
Formula:
=IF(ISERROR(MATCH(A3;FOLHA2!C2:C5;0));"";INDEX(FOLHA2!K2:K5;MATCH(A3;FOLHA2!C2:C5;0)))
Thanks in advance for any ideas !
Cross posted at Ozgrid.
Bookmarks