Thread: Link two Work Sheet by common column

Hi,

I have two work sheet in separate two Excel files. Following are the details

Work Sheet 1
Column A Column B Column C
Item nr Price Quantity

Work Sheet 2
Column A Column B Column C
Item nr Location Weight

The Column A in both sheets contains the same 'item nr' (parent column). I want to combine both the work sheet so i can get the following

Resultant Work sheet
Column_A Column_B Column_C Column_D Column_E
Item nr Price Quantity Location Weight

Can anyone tell me how can i do that in Excel?

thanks in advance

/tahir