I need a formula for Google Sheets that can do the following between workbook 1 and workbook 2:

Workbook 1 needs to pull the cost from workbook 2.
The source in workbook 1 is slightly incomplete (e.g. ABC100L) from workbook 2 as there are multiple vendors (vendor 1: ABC100L.3N, vendor 2:ABC100L.4N, etc.)
Currently, my formula is pulling the first cost is sees from workbook 2, I need to have the lowest cost.

I am currently using this formula but having trouble to add MIN value in there :


Is there a better function that can do what I need?
Thank you.