Vlookup of multiple sheets

[Yelik]

Hello!

I'm working on comparing valuest from two different periods for two firms that are selling different goods (item nrs).
I'd like to vlookup the values from 2010 and inplement them to the quantities from 2011.
Eg. vlookup of firm12 with item nr. 10001 would result quantitiy from 2010 (14,00)
Eg.2 vlookup of firm12 with item nr. 10053 would result quantitiy from 2010 (0,00 because it does not exist)

See the picture below for addtitional info:
http://shrani.si/f/3W/Kl/3xdZfml5/untitled-1.jpg

I would really appreciate it someone could help me out

[Fotis1991]

Hi Yelik and welcome to the forum.

It is far better for someone who wants to help you to attach a workbook and not a photograph.
In this case, to check what to do, again i re-creating a workbook.

Now in your case I give you a solution using the ΙΝDEX and double ΜΑΤCH functions
If we assume that the data of 2011 starting from column A and row 3 and 2010 starting in column G, then in d3, put the formula.

Please Login or Register  to view this content.

Hope to helps you.

Regards

[Yelik]

Great!
Thanks for you quick reply. It worked for the first line... but how do I manage it the same for every result in cell? if I continue to copy paste the formula in each row the results arent correct anymore because formula itself moves also...
eg.
=INDEX(T2:T10000;MATCH(A2:A10000;P2:P10000;0);MATCH(C2:C10000;R2:R10000;0))
and then next rows in same cell:
(copy paste)=INDEX(T3:T10001;MATCH(A3:A10001;P3:P10001;0);MATCH(C3:C10001;R3:R10001;0))
(copy paste)=INDEX(T4:T10002;MATCH(A4:A10002;P4:P10002;0);MATCH(C4:C10002;R4:R10002;0))
and so on... the results are not correct because formula
can I fix so the numbers won't move as I continue to copy paste the formula down the rows.

I usually fixed that in Vlookup by using formula like this sample :
=VLOOKUP(A:A;H:K;3;FALSE) (without any numbers of rows....)

It does not work in your formula but i dont know why

I tried this formula but it still does not work, because when I copy paste the formula the row numbers change:
=INDEX(T2:T10000;MATCH(A:A;P2:P10000;0);MATCH(C:C;R2:R10000;0))
(copy paste) =INDEX(T3:T10001;MATCH(A:A;P3:P10001;0);MATCH(C:C;R3:R10001;0))
and so on....

[Fotis1991]

Hi

Because of Forum's problems, just now, saw your message

=INDEX(T2:T10000;MATCH(A2:A10000;P2:P10000;0);MATCH(C2:C10000;R2:R10000;0))
and then next rows in same cell:
(copy paste)=INDEX(T3:T10001;MATCH(A3:A10001;P3:P10001;0);MATCH(C3:C10001;R3:R10001;0))
(copy paste)=INDEX(T4:T10002;MATCH(A4:A10002;P4:P10002;0);MATCH(C4:C10002;R4:R10002;0))

You just need to lock the ranges...
=INDEX($T$2:$T$10000;...........

If you still have problem, pls attch a sample workbook.