It is a stock analysis chart, As there are some missing data so I created a sheet for the missing data, and need to use a indirect function look up that missing data sheet, it's just returns a ref error. The missing data sheet is a dynamic range as I want the future missing data will be automatically lookup to my summary sheet. What should I do Guys? Thanks in advance