Name Manager and Cell Range

[bullcreel]

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.

 

[steve the fish]

That formula cannever work with a single celled lookup range as you are asking it for the 2nd column of that range where the lookup value is found. It doesnt have one. ATL must refer to a range that has at least two columns.

 

[bullcreel]

Atl refers to a range that has 10 columns. I thought i could just add the cell Reference "A2" which has Atl in it. That way if cell A2 changes, it will refer to another tab like CHC for example

 

[steve the fish]

Oh i see. So instead of A2 try INDIRECT(A2)

 

[bullcreel]

Tried =vlookup(datevalue($A$4),indicrect(a2),2,0)
Didnt work
Also I jut want to thank you for answering so quickly

 

[bullcreel]

Tried =vlookup(datevalue($A$4),indicrect(a2),2,0)
Didnt work
Also I jut want to thank you for answering so quickly

Sorry...typo, meant indirect

 

[steve the fish]

What does didnt work mean?

 

[bullcreel]

What does didnt work mean?

When I put in indirect, it didnt work

 

[steve the fish]

You need to help me a bit here as i cant see the workbook. What does it do?

 

[bullcreel]

I got it working. Somehow the cell references for my ATL name manager got changed. When I fixed it and then put in indirect, it started working...Thank You vrey much