Nel post
*Groovy_Kincaid* ha scritto:

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

I think th simplest way to accomplish your need is to add a first in each
workbook in which you can concatenate by the & operator the other two
columns of reference and use this new "super index" as reference for
VLOOKUP.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy