Works like a charm but it puts me in the same problem as when I save it as a regular 07 excel workbook, its got to be viewable in excel 97-03.

I might just have to save it as 07 then copy and paste values only into a 97-03 version, its a headache but I don't know of another solution.

Is VLOOKUP not supported in 03 or something?