eaveni4287
New Member
 Joined
 Aug 20, 2020
 Messages
 4
 Platform

 MacOS
VLOOKUP will only match the first row value and then continues to replicate that value when I copy/paste it down the entire column. It won't change the formula from $A$1 to $A$2, etc. It just stays at $A$1.
It is set to Automatic so it is NOT that issue. I have also tried removing the $ in front of each of the A and the 1 and then it stops matching correctly all together. It is performing this error for every single sheet I try. New sheets, old sheets, any sheets. It is like the function has stopped working correctly all together. I have spent hours trying to figure out what is going on and I am all out of options. Someone please help!
Here is the formula:
=VLOOKUP($A$1,[Book6]Sheet1!$1:$1048576,2,FALSE)
Screenshot attached for reference.
I am on a Mac if that helps. Not sure what version of Excel I'm using.
It is set to Automatic so it is NOT that issue. I have also tried removing the $ in front of each of the A and the 1 and then it stops matching correctly all together. It is performing this error for every single sheet I try. New sheets, old sheets, any sheets. It is like the function has stopped working correctly all together. I have spent hours trying to figure out what is going on and I am all out of options. Someone please help!
Here is the formula:
=VLOOKUP($A$1,[Book6]Sheet1!$1:$1048576,2,FALSE)
Screenshot attached for reference.
I am on a Mac if that helps. Not sure what version of Excel I'm using.