Unanswered: Lookup to Pull All Matching Values in a Column
Can someone tell me which Lookup Function to use to locate multiple values that are identical?
Example: I have a Column with job numbers and there could be 2 to 10 job numbers with the same number associated to a work order number.
So, how can I do a lookup to pull all of the job nums? A vLooup will only pull the first job num, and I need all of them.