Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    394
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Copying data with two criteria, from a grid work sheet to another worksheet

    I have a workbook with a tab called SOURCE that has data in a grid format. I would like to have a formula that would look at two criteria ( rows & colums) CODE # and EXPENSE TITLE AND copy the amount and to the working sheet ( blank worksheet) in the proper cell.

    I am attaching a simple work book with the two tabs. The RED highlighted row in the source is copied onto the WORKING SHEET for illustrative purposes.

    I would like one formula to accomplish this and not a VLOOKUP in each column. Does Match/Index do this?

    Is this doable at all.

    Thanks
    Attached Files Attached Files

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,852
    Thanks
    146
    Thanked 724 Times in 658 Posts
    MNN,
    On the Working Sheet, enter these formulas then copy down:

    B2 =IFERROR(INDEX(SOURCE!$A$2:$E$24,MATCH('WORKING SHEET'!$A2,SOURCE!$A$2:$A$24,0),3),"")
    C2 =IFERROR(INDEX(SOURCE!$A$2:$E$24,MATCH('WORKING SHEET'!$A2,SOURCE!$A$2:$A$24,0),2),"")
    D2 =IFERROR(INDEX(SOURCE!$A$2:$E$24,MATCH('WORKING SHEET'!$A2,SOURCE!$A$2:$A$24,0),5),"")
    E2 =IFERROR(INDEX(SOURCE!$A$2:$E$24,MATCH('WORKING SHEET'!$A2,SOURCE!$A$2:$A$24,0),4),"")

    HTH,
    Maud

Posting Permissions

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