With the pieces of the name in B1 and C1:

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

David Gibson wrote:

Hi

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

Many thanks - David

--
David Gibson

--

Dave Peterson