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.

Alezi, welcome to the forum. I see you just registered, and you had to state your Excel version during the process. Is there any particular reason you selected 2003 when you're in fact using 2007? This tidbit is meant to help us help you, so don't make it harder, please.

Hi,

put this formula in J4 and copy down

=IF(ISBLANK(I4),"",VLOOKUP(I4,$C$4:$E$17,2,FALSE))

put this formula in K4 and copy down

=IF(ISBLANK(I4),"",VLOOKUP(I4,$C$4:$E$17,3,FALSE))

I think with the second part of your question you'd like to create a drop down list in column I with all the profile names in column C. This is called data validation.

To do this, select cell I4, then click Data Validation on the Data ribbon.
- select Allow: List
- in the Source field put
=$C$4:$C$17
- now copy I4 and use paste special - Validation to paste it in the other cells in column I

If in your real workbook the two tables are on different sheets, you need to create a range name for your data in column C and in the data validation source use the range name like

=MyRange

See attached.