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


--
Weasel
------------------------------------------------------------------------
Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206
View this thread: http://www.excelforum.com/showthread...hreadid=543451