Hello.

I got two lists containing part numbers. The same part numbers are on
the two list but each list has some other details that are diffeerent
between the two lists. The two lists are in one workbook on different
sheets named "list1" and "list2".
"List1" contains columns A and B. A = Part number , B = Price.
"List2" contains columns A and B. A=Part number, B=weight.


Part one: I would like to go through each part number on one of the
list and for each part I would like to check if it is in the other list
as well. I guess I need to do a loop of one kind that do this look up.

Part two: In the loop I would like to do this. If the part number exist
in "list2" I would like to copy "List2" column B:s value to "list1"
column C and so on. I would really like know how I can expand this
function as well.


I really hope someone can help me with this. I only need to know the
basics.

/Anders


--
a94andwi
------------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=556905