Something Like a Multiple Look Up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
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!!!
Click to expand...

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
 
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.
 
Back
Top