ExcelBanter - VLookup with concatinated named range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLookup with concatinated named range (https://www.excelbanter.com/excel-worksheet-functions/27865-vlookup-concatinated-named-range.html)

David Gibson

VLookup with concatinated named range

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

Dave Peterson

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

All times are GMT +1. The time now is 09:19 AM.