if the table column that is being used for column index contains formuales
the vlookup results in an error message unless that column is paste special
with values. Is there any way to overcome this ?

Thanks
--
Cheers !