Home |
Search |
Today's Posts |
#1
|
|||
|
|||
matching and lookup??
Assuming your data starts in A2, with the headers in row 1, and the Item# is
in D1, use this array formula - entered with Shift+Ctrl+Enter =SUMPRODUCT(--(B2:B8=D1),--(C2:C8=MAX(IF(B2:B8=D1,C2:C8,0))),A2:A8) "eoht" wrote: Job # Item # Quantity 51 100 10 85 105 9 64 103 8 78 103 3 45 100 7 53 101 9 24 101 6 I'm trying to find a function that will let me find the "Job #", by matching the "Item #" and the max number of "Quantity" used. For example, if I know that "Item#" = 100 has a max. of 10 quanities used, I want to find a function that will let me find the "Job #" of that quantity and Item # is 51. Any Suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/ Lookup formulas and fuzzy matching | Excel Worksheet Functions | |||
Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
Matching unsorted lookup values | Excel Worksheet Functions | |||
How do I LOOKUP text values | Excel Worksheet Functions | |||
Lookup Function - Specific Values | Excel Worksheet Functions |