Hiya,

I have a dynamic range set up (named range) - this is 8 columns across and
loads (varying) of rows down. Lets call it DATA.

For a vlookup, however, I only want to look at columns 3-7.

Is there anyway that I can filter the existing dynamic range rather than
creating a new one?

PS I know it would make no difference if I have 3-8 in the range, but I want
to learn how to do filter at both ends for something else.

Thanks guys!

B