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

1. ## 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

2. 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
•