Creating a range name from cell values

[Troy Boy]

OK.. here's today challenge!
<cr>
I need to use the value in cell A1 (which is an employee number) concantanate a "_" to the beginning to get _EMPNUM (_55555) and then pass this as the range name in a VLOOKUP.... is this possible?

 

[Aladin Akyurek]

On 2002-05-03 10:23, Troy Boy wrote:
OK.. here's today challenge!
<cr>
I need to use the value in cell A1 (which is an employee number) concantanate a "_" to the beginning to get _EMPNUM (_55555) and then pass this as the range name in a VLOOKUP.... is this possible?

Yes, if the corresponding name is already defined/assigned to the relevant range. the syntax would be:

=VLOOKUP(lookup-value,INDIRECT("_"&A1),...)

The result of "_"&A1 must, as I said, must exit as name in the workbook.