I have a spreadsheet #1 as follows:
column A - Loc
column B - Division
Column C - item name
Column D - Sales units
I have another spreadsheet #2 as follows:
Column A - Division
Colum B - Item name
Column C - Sales units
I am trying to add any items not already listed on spreadsheet 1 from spreadsheet 2.
IF spreadsheet 1 column b = Spreadsheet 2 column A, if Spreadsheet 2 col b is not on Spreadsheet 1 column C, add to Spreadsheet 1 column C item name and Sales units(column d).
I can work with just adding the item names missing from spreadsheet 1 and vlookup sales.
Cant get to work?
Bookmarks