Vlookup is a great function. We use it every day populate delivery notes. We have a delivery note template where the individual fields are all vlookup references to the main job data sheet.
Prior to sussing out vlookup, we hd to write the info out each time which was a time consuming duplication of effort. I like vlookup.