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?