Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
matching and lookup?? | Excel Worksheet Functions | |||
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 |