VLOOKUP use in offer - cell the same form and shape as the original

In Excel, I want to prepare a quote where I would automatically enter the data into the quote from a file containing all the data.   I have two problems that I cannot solve or cannot find a solutio...