# Name Manager and Cell Range

#### bullcreel

##### Board Regular
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.

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### steve the fish

##### Well-known Member
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

##### Board Regular
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

##### Well-known Member
Oh i see. So instead of A2 try INDIRECT(A2)

#### bullcreel

##### Board Regular

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

#### bullcreel

##### Board Regular
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

##### Well-known Member

What does didnt work mean?

#### steve the fish

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

#### bullcreel

##### Board Regular
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

Replies
15
Views
243
Replies
1
Views
114
Replies
7
Views
143
Replies
2
Views
109
Replies
1
Views
78

1,129,514
Messages
5,636,782
Members
416,940
Latest member
JohanT

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back