software

Hi Everybody, thank you in advance for your help

I am trying to two seperate spreadsheets into one. The spreadsheets are
two different versions of the same list. One is older and one is newer.
The spreadsheets look like this.

Spreadsheet 1

SKU #_______Category_______Keyword

123_________(Blank)________Preschool
234_________(Blank)________Classroom

etc...Spreadsheet 2 (This is the newer spreadsheet and it contains new
products that are not in the old spreadsheet.)

SKU #_______Category_______Keyword

123_________School_________(Blank)
234_________School_________(Blank)
345_________School_________(Blank) gt;New product not in Spreadsheet 1I need to merge these two spreadsheets, to get the category data, and
the keyword data into the same spreadsheet. As well as this, I need the
new products that are only in spreadsheet 2 and do not have a match in
spreadsheet 1 to show up in the merged spreadsheet as well. Can anybody
help me out with this. Thank you very much.

Will Taylor--
wstaylor81
------------------------------------------------------------------------
wstaylor81's Profile: www.excelforum.com/member.php...oamp;userid=29495
View this thread: www.excelforum.com/showthread...hreadid=493522On your spreadsheet with the new data, do a VOOKUP of the SKU's against the
SKU's on the old data. A #N/A will be returned for the new items.

=VLOOKUP(new_sku_cell,range_of_old_sku's,1,false)

quot;wstaylor81quot; wrote:

gt;
gt; Hi Everybody, thank you in advance for your help
gt;
gt; I am trying to two seperate spreadsheets into one. The spreadsheets are
gt; two different versions of the same list. One is older and one is newer.
gt; The spreadsheets look like this.
gt;
gt; Spreadsheet 1
gt;
gt; SKU #_______Category_______Keyword
gt;
gt; 123_________(Blank)________Preschool
gt; 234_________(Blank)________Classroom
gt;
gt; etc...
gt;
gt;
gt; Spreadsheet 2 (This is the newer spreadsheet and it contains new
gt; products that are not in the old spreadsheet.)
gt;
gt; SKU #_______Category_______Keyword
gt;
gt; 123_________School_________(Blank)
gt; 234_________School_________(Blank)
gt; 345_________School_________(Blank) gt;New product not in Spreadsheet 1
gt;
gt;
gt; I need to merge these two spreadsheets, to get the category data, and
gt; the keyword data into the same spreadsheet. As well as this, I need the
gt; new products that are only in spreadsheet 2 and do not have a match in
gt; spreadsheet 1 to show up in the merged spreadsheet as well. Can anybody
gt; help me out with this. Thank you very much.
gt;
gt; Will Taylor
gt;
gt;
gt; --
gt; wstaylor81
gt; ------------------------------------------------------------------------
gt; wstaylor81's Profile: www.excelforum.com/member.php...oamp;userid=29495
gt; View this thread: www.excelforum.com/showthread...hreadid=493522
gt;
gt;