MySuperFund You cannot put the range of cells in the vlookup statement, you must put in the array name!
That's actually not right, you can put in a range of cells. My previous post proves it. I do admit it helps and its much easier to have "named" ranges. But i thought i would correct you on your post.
Cheers Mark
