Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    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,639
    Thanks
    115
    Thanked 650 Times in 592 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
  •