| 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 |
| 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 | |||
Threaded Mode
