I do this with a Vlookup function. You have to set it up to search your parts
number column and pull the second column value with the cost. You'll probably have to do some formatting to get it right, but once it's setup it's fast. I typically use it when I need to verify values across a list of 4,000+ different claim id's.