I have a worksheet "Spend Detail" with 8000+ part numbers, A7:A8253 and the
unit prices for each part # is in, G7:G8253 (Part # in A7 unit price is in G7
and so on).

I have now created another worksheet "ABC" but with only 120 or so part #'s
(that were filtered from Spend Detail) but didn't bring over the unit costs.
Is there a function to take the part #'s on sheet ABC and go and look for it
on sheet Spend Detail and bring over the corresponding unit cost?

It would take to much time to filter through and find the unit costs manually.

THanks,
BAS