View Single Post
  #1   Report Post  
eoht
 
Posts: n/a
Default matching and lookup??

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?