Name Manager and Cell Range

bullcreel

Board Regular
Joined
Aug 25, 2016
Messages
139
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
Joined
Oct 20, 2009
Messages
8,388
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Aug 25, 2016
Messages
139
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
 

bullcreel

Board Regular
Joined
Aug 25, 2016
Messages
139

ADVERTISEMENT

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

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,388
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

What does didnt work mean?
 

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,388
Office Version
  1. 365
Platform
  1. Windows
You need to help me a bit here as i cant see the workbook. What does it do?
 

bullcreel

Board Regular
Joined
Aug 25, 2016
Messages
139
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
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top