Hi

Does anyone know of a way I can nest a range name within a look up function that will change based on the row it is on.

For example n cell A11, I have a vlookup of an employee name as the lookup value, the table array is a range for a week (eg FebWk1) and the col index number increments across the file.

The formula reads like this: =VLOOKUP($A$10,FebWK1,B$8)

Now, in cell a12, I want the same formula, but for the range name febWk2. Is there anyway of getting excel to automatically update the table array name?