Index & Match with Multiple criteria

**connollet** · 10-03-2012, 02:42 PM

I have a spreadsheet showing Customer, Assembly #, Rev, and Requirements in columns A1:D22. I then have dates in E1:BO1. In the cells E2:BO22 are the quantity requirements for that date. I need to index by assembly to give me the date and quantity needed, under a specific requirement. I have tried writing several INDEX functions with nested MATCH functions, but nothing has been working. Any help would be greatly appreciated!!

**ConneXionLost** · 10-03-2012, 02:49 PM

How to attach a sample workbook:

1. Below the "Quick Reply" thread frame, click the "Go Advanced" button.
2. On the edit toolbar, click the "Attachments" button.
3. In the "File Upload Manager" window, click the "Add Files" button.
4. In the "Upload Files from your Computer" window, click the "Select Files" button.
5. In the Windows Explorer window, locate and select your workbook, then click the "Open" button.
6. In the "Upload Files from your Computer" window, click the "Upload Files" button.
7. In the "File Upload Manager" window, click the "Done" button (lower right of screen).

**Cobbhill** · 10-03-2012, 02:52 PM

Hi I am trying to retrieve the quantity for a part number from all locations in another workbook. The following is close but it brings back the quantity for 2 part numbers below the ones I want. Any help would be aprreciated, I am very new to Excel.

=INDEX([FSL_Inventory.xls]DATA!$D$3:$J$34159,SMALL(IF([FSL_Inventory.xls]DATA!$D$3:$J$34159=$A$5,ROW([FSL_Inventory.xls]DATA!$D$3:$J$34159)),ROWS(1:1)),3)

**ConneXionLost** · 10-03-2012, 02:54 PM

Cobbhill,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.