I had a post with the following title "Vlookup using VBA". I got help, and it worked out fine in the example I uploaded BUT... The sheet names in my project are named as dates and as such referencing these by the indirect formula I get #ref - does anyone really smart know how to get round this?
I am posting an example file to show you all what I mean.
//Robert