Excel VBA create columns and populate with data based on another column -

okay have create 2 new columns , populate data worksheet if the values column matches. i'll break make easier understand. there 2 worksheets namely; "july15release_dev status" , "july '15 rel". both of these worksheets have header of "erequest id" column a. need create 2 new columns "july15release_dev status" , populate data "july '15 rel" if "erequest id" matches specific row of data.

by creating 2 new columns , populating data, doesn't have "creating populating", copying exact 2 columns fine, long data remain intact. data in date/time format if affects anything. in advance i'm total beginner @ this!

let's say, before vlookup, our july15release_dev status sheet looks this:

            b          c 1 erequestid  firstname  lastname 2 10 3 30 

july '15 rel looks this:

            b          c         d .... 1 erequestid  firstname  lastname  age 2 10          jon        smith     40 3 20          matt       kahn      50 

our task firstname , lastname july '15 rel july15release_dev status.

after adding vlookup in july15release_dev status, sheet looks this:

            b                                                        c 1 erequestid  firstname                                                lastname 2 10          =vlookup(sheet1!a2,'july ''15 rel'!$a$1:$c$3,2,false)    =vlookup(sheet1!a2,'july ''15 rel'!$a$1:$c$3,3,false) 3 30          =vlookup(sheet1!a3,'july ''15 rel'!$a$1:$c$3,2,false)    =vlookup(sheet1!a3,'july ''15 rel'!$a$1:$c$3,3,false) 

give shot , see how works you.