To achieve what you wanted you only have to insert a column in th
product sheet. this column will be the a column and the b column wil
have the product pf_id same as the other two sheets.
you could hide the inserted column.

Th other way is to have a formula in the b columns of sheet 2 and shee
3 which will refer back to sheet1 a column.

I.e for example in the sheet dept_prod cell B1 you could enter
=product!A1 and extend that down the column.

have fu

--
bill

-----------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...info&userid=82
View this thread: http://www.excelforum.com/showthread.php?threadid=40130