software

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: www.excelforum.com/member.php...oamp;userid=27206
View this thread: www.excelforum.com/showthread...hreadid=543451In the blank inventory column on Sheet1 (D2) enter as an array formula i.e.
enter with Ctrl-Shift-Enter

=INDEX(Sheet2!$D$2:$D$100,MATCH(1,($A2=Sheet2!$A$2 :$A$100)*($B2=Sheet2!$B$2:$B$100)*($C2=Sheet2!$C$2 :$C$100),0))

Copy down as required (and change ranges to suit)

HTH

quot;Weaselquot; wrote:

gt;
gt; I've got a workbook that has two sheets. In sheet one column A through D
gt; has Styles, Colors, Sizes, and Inventory #. These are my master list and
gt; contain every single style, color, and sizes but the inventory column is
gt; blank
gt;
gt; In a seperate sheet I've got the same headers except instead of a
gt; master list it has only certain styles, colors, and sizes along with
gt; the inventory for each.
gt;
gt; What I'm trying to do is insert a formula in column D of the first
gt; worksheet (the blank Inventory column) that will look in the second
gt; sheet and if it finds a row with the same style, color, and size as the
gt; master list row then the inventory # listed in the second sheet will be
gt; displayed.
gt;
gt; Thanks in advance for any help
gt;
gt;
gt; --
gt; Weasel
gt; ------------------------------------------------------------------------
gt; Weasel's Profile: www.excelforum.com/member.php...oamp;userid=27206
gt; View this thread: www.excelforum.com/showthread...hreadid=543451
gt;
gt;