G
Guest
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
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