AND YET another multiple criteria Lookup question

I am not an Excel expert. Most of what I do in excel I learn as a result of forum searching via Google.
I have a workbook that, when I open it, refreshes several queries from an Access database and fills in all but the first worksheet with refreshed data.

I am attaching my workbook. MSD OPEN ORDERS

I thought I found the answer here in this forum on the following thread http://www.excelforum.com/excel-gene...-question.html....but I cannot get the solution there to work for me.

Perhaps someone can help please.

I need the Cell M2 on the first worksheet "OOR" (and all below it) to automatically fill in with the correct Job #. It should find this information on worksheet "Q1" in Column E.

It needs to match the information in column A and B from the first worksheet "OOR" to the corresponding information in columns B & C in the second worksheet "Q1"....basically I need the PO number and Item number to match in both so it can determine what the job number should be.

Thank you in advance for any help you can offer.



MSD OPEN ORDERS.xlsm

you were pretty much right, with what you had, but your data messed you around. The data in B, sheet2 has trailing spaces. Use this instead...

=INDEX('Q1'!$E$2:$E$21,MATCH(A2&B2,TRIM('Q1'!$B$2:$B$21)&'Q1'!$C$2:$C$21,0))
(still an array formula, so use CSE)

Happy to help