Lookup and Fill

Hi,

I need help with Lookup or any other option to look up data, and put another data to the cell.
Please refer to the screen capture and excel file.

Thank you

Try this in G3:

=INDEX(B:B,MATCH(E3,A:A,0))

or

=VLOOKUP(E3,A:B,2,FALSE)

Thank you!!!!!!