a double vlookup, is it possible?

  • Thread starter Thread starter Kashgarinn
  • Start date Start date
K

Kashgarinn

Hi there, and thank you for reading this :)

I have 2 pivot tables.

Pivottable 1 has 3 columns; Type of item, Price of each item, Tota
sold in this transaction

Pivottable 2 has 3 columns; Type of item, Price of each item, Profit o
each item

these are 2 pivottables, as these are from 2 access databases, th
first one is called transactions, and pivottable 1 is from tha
database, and the other one is called sell orders, and pivottable 2 i
from that database.

What I want to do is in a new column next to pivottable 1 lookup th
type of item from pivottable 2, see that it matches the type of item t
the left of the cell, then lookup the price, to make sure I have th
same type and price, and lookup the correct profit.. then I can easil
multiply profit with total sold..

What's the easiest way to do this?

Thanks a lot for any replies.

K
 
Hi
if I understood you correctly try the following array formula (entered
with CTRL+SHIFT+ENTER):
=INDEX('sheet2'!$C$1:$C$100,MATCH(1,('sheet2'!$A$1:$A$100=A1)*('sheet2'
!$B$1:$B$100=B1),0))
 
Back
Top