I have 2 worksheets. Worksheet 1 has a list of all outstanding sales orders
containing the following, customer purchase order no, works order no.
Worksheet 2 has the same information for but from our old system.

The customer purchase orders will match on both systems but the works order
numbers will not.

What I am wanting to do is to corrolate works orders from the old system to
works orders from the new one using the customer purchase order as the search.

I have tried using VLOOKUP but this will only result the 1st finding.

Is there any other way to correlate this data.

Thanks

Regards