Copying Vlookup Returns Same Lookup Value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

christopher.margol@gmail.com - 10 Oct 2007 21:24 GMT

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

Reply to this Message

alex - 10 Oct 2007 21:31 GMT

> 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
[quoted text clipped - 5 lines]
> Thanks,
> Chris

hit "F9", maybe you deactivated the automatic calculation

Reply to this Message

christopher.margol@gmail.com - 10 Oct 2007 21:48 GMT

On Oct 10, 1:24 pm, christopher.mar...@gmail.com wrote:

> 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
[quoted text clipped - 5 lines]
> Thanks,
> Chris

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

Reply to this Message