Hi Yaron
The safest way is probably to use VLOOKUP Worksheet Formula
http://www.mvps.org/dmcritchie/excel/vlookup.htm
assuming there are no both sheets have all of the index items.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Yaron Assa" wrote in message ...
Hey all.

suppose i have two excel sheets, and they both got a common column that acts
as an index column (e.g. s/n of parts). the sheets have a different number of
values for each index num. and have different columns.

is there a way to created a unified sheet which will contain both sheets
columns, matched by the index column?

thanks!