Paste into B2 then fill down.

Formula: copy to clipboard
=INDEX(Sheet3!B:B,MATCH(E2,Sheet3!A:A,0),0)