Try:

=VLOOKUP(E3,IPs!A:B,2,0)

copied down