Thanks, the index function worked as I wanted it. Thanks again!!!

"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!!!