Formula to lookup matching data
 

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

Formula to lookup matching data
 

In 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

"Weasel" wrote:


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