W
Weasel
I've got a workbook that has two sheets. In sheet one column A through D
has Styles, Colors, Sizes, and Inventory #. These are my master list and
contain every single style, color, and sizes but the inventory column is
blank
In a seperate sheet I've got the same headers except instead of a
master list it has only certain styles, colors, and sizes along with
the inventory for each.
What I'm trying to do is insert a formula in column D of the first
worksheet (the blank Inventory column) that will look in the second
sheet and if it finds a row with the same style, color, and size as the
master list row then the inventory # listed in the second sheet will be
displayed.
Thanks in advance for any help
has Styles, Colors, Sizes, and Inventory #. These are my master list and
contain every single style, color, and sizes but the inventory column is
blank
In a seperate sheet I've got the same headers except instead of a
master list it has only certain styles, colors, and sizes along with
the inventory for each.
What I'm trying to do is insert a formula in column D of the first
worksheet (the blank Inventory column) that will look in the second
sheet and if it finds a row with the same style, color, and size as the
master list row then the inventory # listed in the second sheet will be
displayed.
Thanks in advance for any help