Excel 2007 : Excel 2007 connection between two tables

Hi guys,
This is my first post here and I hope somebody could help me, I working in Excel 2007 and I need to make connection between two tables (Table 1 and Table 2), in first table there are list of profiles with sides which make this profile, second table is production plan, wont to do if I put some profile in column I (Table 2) profile which exist in Table 1 automatically show me correct sides (column J and column K) for this profile.
One more question, how I could put whole column C from table 1 in every single cell in column I table 2(like filter).
I’m completely sure that you could help me and thank you in advance.