How to bring data fron one table into another table

[tazz]

Hello,

I have 2 tables, one with data and the other one needs to update from the firs one according to the job # I input.This is an example:

[pre]

Table 1:
job#  Jun-12 Jul-12  Aug-12  Sept-12 .....
333     55      71      23        14
111             19                83
222                               17

Table 2:
job#  Jul-12   Aug-12   Sept-12
111
222
333

[/pre]
Job# and month in Table 2 will change every month.

Thank you.

 

[Luke M]

Assuming Table1 is in A1:E5, and Table 2 is in AA1:AE5, formula in AB2 is:

=INDEX($B$2:$E$5,MATCH($AA2,$A$2:$A$5,0),MATCH(AB$2,$B$1:$E$1,0))


More examples of this formula:

http://www.contextures.com/xlFunctions03.html

 

[Jai9]

Hi,


with the first table in A19:E22 and second in A25:E28.


Try in B26 and drag down.


=INDEX($A$19:$E$22,MATCH(A26,$A$19:$A$22,0),MATCH($B$25,$A$19:$E$19,0))


Jai

 

[tazz]

I tried both solutions and I got an error every time. This formula brings the job # and not the value corresponding to Job# and the month.Do you know how to fix it?

 

[Luke M]

I was assuming that in Table 2, you were giving the Dates and job numbers, and the formula just needed to lookup the correct return value from Table 1. Is this not correct?


Also, if you could post the exact formula you are using as it's written in your workbook, that would help us know what is/isn't working.

 

[tazz]

I found out where was the error.Instead of AB$2 at second Match should be AB$1.

Now is working perfect. Great solution !

Thank you.

 

[Luke M]

Hurrah! Thanks for letting us know that you found a solution. =)