View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Filtering a dynamic range

If you want to use column B for the lookup range in a vlookup, just set your
formula as =vlookup(lookupvalue,B:G,column numberusing B as 1, 0)
if you want to extract anything from column A you can use index-match
formulas.

"Basil" wrote:

Instead of the range looking at Columns A to H, I want to look at columns B
to G.

"bj" wrote:

I do not understand your question. please give me your definition of filtering

"Basil" wrote:

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