You need to go google Product() as an array vs Range as it confuses the buggery out of me every time I try to use it.

To make it work on the work spreadsheet you need to set the array, can't remember how, or use the vlookup trick of concatenating the key in the target sheet.
There's a way to do a backwards vlookup but forgotten how.