Inserting named ranges into Match and Vlookup

  • Thread starter Thread starter dancing fish
  • Start date Start date
D

dancing fish

I want the named range in my match and lookup functions to be variable
dependent on another cell value (let's say the value in cell d3).

For instance if the value in cell d3 is Group1 then i want the match
function to be =Match(c10,Group1,1).

However, if the value in cell d3 is Group2 then i want the match
function to be =Match(c10,Group2,1). And so on.

I've tried =Match(c10,d3,1) and =Match(c10,"d3",1) but neither of these
work.

I also want to do the same thing in my vlookup function.

Is this possible? If not, is there a work around? I can do some VBA
coding if that is necessary.
 
Hi you have to use INDIRECT. So for your exmaple try
=Match(c10,Indirect(d3),1)

HTH
Frank
 
You can't have spaces in named ranges but assuming you use Group1 i D3

=MATCH(C10,INDIRECT(D3),0)
 
Back
Top