This, will also work

=INDEX(Products!$A$2:$B$5, MATCH(order!$A$2,Products!$A$2:$A$5,0),2)

In B2 on the order tab