Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup if = to 2 values
What formula should i use to give me the quantity for each store depending on sale type for the following table: Sheet 1 (contains shop info) Shop Sale Type AAA 001 BBB 001 CCC 003 DDD 001 Sheet 2 (contains sales info for all stores) Shop Sale Type Quatity AAA 001 34 FFF 003 12 CCC 004 24 I need a formula to look up both the shop & sale type to give the quantity per store per sale type. Eg. AAA 001 should return a quantity of 34 from sheet 2. Hope i explained that ok. Thanks in advance -- loscherland ------------------------------------------------------------------------ loscherland's Profile: http://www.excelforum.com/member.php...fo&userid=6709 View this thread: http://www.excelforum.com/showthread...hreadid=529145 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup if = to 2 values
try this =INDEX(C:C,MATCH(D1&E1,$A$1:$A$5&$B$1:$B$5,0)) This is an array formula so you must Ctrl,shift,enter for it to work for this example D1 And E1 is your criteria A1:A5 is shop B1:B5 is sale type column C is your qty -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=529145 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning multiple corresponding values using lookup in a list | Excel Discussion (Misc queries) | |||
How do I use Lookup to return a row of values eg. 6 cells | Excel Worksheet Functions | |||
Sum values in multiple sheets using Lookup to find a text match | Excel Worksheet Functions | |||
How do I lookup data with two comparison values? | Excel Worksheet Functions | |||
vlookup using two lookup values? | Excel Worksheet Functions |