freakofnature
New Member
- Joined
- Jan 13, 2018
- Messages
- 10
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.
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.