Lookup is the name of an Excel function. Give your named range a different
name, such as LOOKUPTABLE.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"NathanG" wrote:

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