Hello,

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.

I am using Excel 2010.

Sample:

WO:
3701313811

Job Num:
10139311
10139311
10139311
10139311
10139311