wildcard in named range in formula

[freakofnature]

Doing calculations for my fantasy NFL teams.
I have a sheet with multiple named ranges, FPweek1, FPweek2, etc .
Can I ref that range in a formula, (vlookup in my case) where the number changes based on a number at the top of the column . ex: vlookup(playername,FPweek(a1),4,false) - where A1 has the value 1
so when I copy this formula to the next column the FPweek# changes.

 

[Jonmo1]

Sorry, my fault... I read what you wrote incorrectly.

No worries. You're not the first, and you won't be the last to misread something on the internet