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
|