Lookup and Copy Data

[fruitchunk]

In column A I have a list of names
In column B I have a list of id# numbers

In column D I have a list of some names of column A

Now I need a formula to lookup the id# numbers in column B and copy it to
column E matching to the names

Please help

 

[Gaurav]

=VLOOKUP(D1,$A$1:$B$10,2,FALSE)

adjust the range as per the requirement.