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?
|