Results 1 to 20 of 20

Trying to merge two formulas in one cell.

Threaded View

  1. #1
    Forum Contributor Anka's Avatar
    Join Date
    08-25-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2016
    Posts
    174

    Trying to merge two formulas in one cell.

    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: copy to clipboard
    =IF(ISERROR(MATCH(A3;FOLHA2!C2:C5;0));"";INDEX(FOLHA2!E2:E5;MATCH(A3;FOLHA2!C2:C5;0))) 
    join to
    Formula: copy to clipboard
    =SE(É.ERRO(CORRESP(A3;Folha2!C2:C5;0));"";ÍNDICE(Folha2!I2:I5;CORRESP(A3;Folha2!C2:C5;0)))


    Case 2 :
    Formula: copy to clipboard
     =IF(ISERROR(MATCH(A3;FOLHA2!C2:C5;0));"";INDEX(FOLHA2!G2:G5;MATCH(A3;FOLHA2!C2:C5;0)))
    join to
    Formula: copy to clipboard
    =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.
    Attached Files Attached Files
    Last edited by Anka; 12-18-2012 at 07:24 PM. Reason: 90% solved of the formula.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1