Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Another way to lookup data | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |