I have this formula...=vlookup(datevalue($A$4),ATL,2,0) which works great
The name manager "ATL" is in its own tab. I want to have numerous tabs that are named: CHC, BOS, etc.
What I am trying to do is build a MLB schedule. I want the Name Manager to be added to the formula from one cell.
Lets say cell A5 formula is =A2, which in this example brings up Atl.
However when add the cell reference to the formula, it does not work. Here is the formula...=vlookup(datevalue($A$4,),A2,2,0)
I would have thought that having a cell reference the name manager, it would come up.
What am i missing.
The name manager "ATL" is in its own tab. I want to have numerous tabs that are named: CHC, BOS, etc.
What I am trying to do is build a MLB schedule. I want the Name Manager to be added to the formula from one cell.
Lets say cell A5 formula is =A2, which in this example brings up Atl.
However when add the cell reference to the formula, it does not work. Here is the formula...=vlookup(datevalue($A$4,),A2,2,0)
I would have thought that having a cell reference the name manager, it would come up.
What am i missing.