Combining Lists within excel.

[Andy]

I'm hoping someone can help here. I'll try to explain the
problem I have.

I have 2 worksheets both containing a product list. I have
entries on one worksheet which I need on the other, so
basically my question is... might there be a way of
combining these two lists so one updates the other with
the missing entries.

Help on this would be great, as they are very large lists
which I dont much fancy the thought of looking through
them manually.

 

[Rita Palazzi]

Are you familiar with the VLOOKUP function? I use it all the time for this type
of problem.

vlookup(Product cell in first sheet, Array in second sheet where left-most column
contains product found on first sheet, column number of cell you want from second
sheet, FALSE looks for exact match)

The key is to make sure you have the array defined as a static array ($ signs in
value), otherwise as you copy the formula down your first sheet, it will move the
array out of scope. You can email me directly if you have any problems.
(e-mail address removed)

Hope this helps.

Rita Palazzi
Senior Engineer/FedEx Express