vlookup help Vlookup not working

[rentonhighlands]

Hello:
=VLOOKUP(AH:AH,'[Copy of Providence SJ Health Services September 2018 V7.xlsb]PSJH Tracking Sheet'!$AN:$BS,32,0)
that is my Vlookup up statement

My problem:
When I double click the bottom right of the cell the vlookup auto fills the same data instead of looking to column AN and finding the new data to populating. In other words the vlookup does not work.

ideas as to why?

 

[jtakw]

Hi,

Your Lookup Value is the Entire Column of AH:AH?

 

[rentonhighlands]

yes
AH is the source column. This column has the data I want to look up from.

 

[jtakw]

Well, you can't use an Entire Column (Over 1 million values) as your Lookup Value (a Single value).

 

[rentonhighlands]

it has worked up to this point

What happens is it is auto filling all the way down instead of using the formula

 

[rentonhighlands]

Well, you can't use an Entire Column (Over 1 million values) as your Lookup Value (a Single value).

What does this mean?

 

[jtakw]

it has worked up to this point

I doubt it, If you have AH1 rather than AH:AH as Lookup value, when you fill the formula down, the formula will change the relative reference of AH1 to AH2, AH3, AH4, AH5, etc.

 

[rentonhighlands]

column AH:AH is all different values. This is the point and the reason I want to use Vlookup is because I use AH:AH to look up against then pull the data from the other workbook.

 

[jtakw]

Then try my suggestion in Post # 7, change AH:AH to AH1 or which ever cell your formula starts, copy the formula down, see what happens.

 

[rentonhighlands]

I solved the issue.
The issue was the calculation mode was set to manual and I set it to automatic.
Automatic is the correct setting.