Fetch data from one sheet to another when user enters data

[Zahid0111]

I have a sheet named "Sheet2", in which two columns has my data. In Column A, i have Equipment ID and In Column B, i have TAO number.
On other sheet named "Final Log", In column E(Equipment ID) and column F(TAO number) i am using the same data
but user will enter this data. Now i want when user enter data in column E, it should automatically fetch it,s TAO number
from Sheet2. Please help me. Attached are snapshots and file

[jindon]

F4
=IF(E4<>"",IFERROR(VLOOKUP(E4,Sheet2!$A$2:$B$27,2,FALSE),""),"")
copy down

[Zahid0111]

Thank you Jindon....this works fine