Hello

I've got a spreadsheet that I need to search on a part number and get it's
price, however there may be multiple part numbers, and the determining
factor would be the revision of that part. such as ...

Part number Rev Price
1234 A 13.00
1787 G 16.50
1234 B 15.00

using the .find method, is there a way to do a search for a part number, and
if multiples are found, get the one that has the latest rev?

Thanks