Hi,

I have a look up on a form which is working perfectly well. I havw to enter
another column inbetween the array. I tried selected the cells that contain
the values I need by holding ctrl and giving the highlighted cells a name. It
appears that if there is a gap in the array, in this case a column, it
doesn't work.

For example

=vlookup(a1,d1:f3,2,false) is OK

but =vlookup(a1,lookup,2,false) is not working where 'lookup' are cells
d1:e3 and cells g1:g3 as I am ignorning column F.

Is there a workaround?

Thanks

Nathan