Copying Vlookup Returns Same Lookup Value

  • Thread starter Thread starter christopher.margol
  • Start date Start date
C

christopher.margol

The Vlookup I created is returning the correct value for the first
record, but when I copy the lookup down the rest of the column, it
simply copies the value returned for the first record. What's up with
this? I've done a lot of lookups and it hasn't done this before. My
guess is that it has something to do with the formatting, but I
haven't been able to figure it out. Please help!

Thanks,
Chris
 
The Vlookup I created is returning the correct value for the first
record, but when I copy the lookup down the rest of the column, it
simply copies the value returned for the first record. What's up with
this? I've done a lot of lookups and it hasn't done this before. My
guess is that it has something to do with the formatting, but I
haven't been able to figure it out. Please help!

Thanks,
Chris
Click to expand...

hit "F9", maybe you deactivated the automatic calculation
 
The Vlookup I created is returning the correct value for the first
record, but when I copy the lookup down the rest of the column, it
simply copies the value returned for the first record. What's up with
this? I've done a lot of lookups and it hasn't done this before. My
guess is that it has something to do with the formatting, but I
haven't been able to figure it out. Please help!

Thanks,
Chris
Click to expand...

No help needed--I figured it out. For whatever reason, when I have
the Essbase add-in running, it causes the above problem--so I just
removed Essbase. Thanks.

Chris
 
Back
Top