Offset doesn't work in closed workbook. You'll have to use INDIRECT. Give us the full file path and we'll give you a formula but bear in mind that this formula will really slow down your file if you have to many of them.