Om my testing VLOOKUP worked OK with your scenario (unless I misunderstand)

Can you give an example of the problem, with the various formulae?

"Sena" wrote:

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 !