VLookup with concatinated named range

[David Gibson]

Hi

Using Vlookup, does anyone know the syntax for the second argumen
(range) for concatinating 2 cells that would make an existing name
range that has already been set-up?

Many thanks - Davi

 

[Dave Peterson]

With the pieces of the name in B1 and C1:

=VLOOKUP(A1,INDIRECT(B1&C1),2,FALSE)