Following SixthSense's instructions, I was able to update the values from a closed workbook. As also mentioned, I suspect the error is with your vlookup formula. If you'd like further assistance, feel free to upload the two workbooks you're working with.