You may use a combination of INDEX and MATCH in an array formula, something
like:
=INDEX(E1:E100,MATCH(1,--(A1:A100=Sheet2!A1)*(B1:B100=Sheet2!B1),0))
Enter it with Ctrl+Shift+Enter. This will look in column E for the value
that has store number equal to the cell A1 in Sheet2, and Transaction type
equal to the cell B1 in Sheet2. Change the ranges and references as
appropiate.

Hope this helps,
Miguel.

"Groovy_Kincaid" wrote:

Hi All,

Long Time Lurker and First Time Poster. I have read the other threads to
look if someone has or had the same issues that I have.

I have information in one workbook. It is report. In column A I have a store
number, in column B I have a transaction type. In column E I have a date. In
column F I have a dollar amount, in column J I have a foreign dollar amount
and in Column M I have a Timing difference.

In another workbook (store summary), I have individual worksheets that feed
another worksheet in the store summary workbook.

What I want to do, is in each store workbook, is to pull in all the
information from the report. I would have the store number and the
transaction type in the store's worksheet as a reference and then return the
date, the dollar amount, the foreign dollar amount and the timing difference.

I have played with the =index array formula as some of you have suggested to
others, and I do not think a vlookup can handle this, unless I am mistaken.

If anyone has any ideas I would love to hear them.

Thanks!!!