John,

I still have a problem. I like the idea of using VBA to return the values
though. Because the part numbers on the Orders sheet may contain spaces it
(at the end of the part number) it won't show a match. Is there a way I can
trim those part numbers first (column F).

Thanks for your help,