match in one range to extract value from another

Originally Posted by StevenM

Which line is the error?

I don't know. The spreadsheet only shows #Value!