|Why do you think it require VLOOKUP?|
I don't think you do, but I'll admt that I don't I completely understand what you are trying to do.
re: then insert the value of Column E on the second spreadsheet.
Insert? Do you mean copy?
...on the second spreadsheet? Do you mean it should end up on the second spreadsheet or should be retrieved from the second spreadsheet?
Is this what you are looking for? This formula will return the value from Sheet2!E1 when Sheet1!A1 = Sheet2!B1
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.