Tim201110,
I think your dutch, because of the index formula.
I'm too, so that was handy.
The index doesn't work, the first worksheet overview is in my file a sheet where all the data is from an index formula. If i use your formula in my file the cell stays empty and i'm sure there is a value. Any idea.
The AG column is not from a index formula also the A, B and C column are not from an index.
I found it, my worksheet names has a space in it. I enclosed the names in ' that worked.
Bookmarks