Make the table you describe, where product is the first column and price is the second column. It is good, but not required, to sort this table ascending by product.

=VLOOKUP(C7,TableLocation,2,0)

Vertical Lookup(WhatToLookFor,WhereToLook,WhatTableColToRet urn,IsCloseOK?)

Don't forget to make the table location be absolute (either with dollar signs or a named range).