VLookup won't work

[tmurcer]

I am trying to run a VLOOKUP, but when I press enter the formula stays on the screen. No typical errors (i.e. #N/A), it just stays locked. Any suggestions?

Note: the sheet that I am referencing for the lookup came from a vendor with somewhat confidential info, and won't allow any changes (presume locked) directly to it.

Thanks,

T

[Paul Lautman]

tmurcer wrote:
> I am trying to run a VLOOKUP, but when I press enter the formula stays
> on the screen. No typical errors (i.e. #N/A), it just stays locked.
> Any suggestions?
>
> Note: the sheet that I am referencing for the lookup came from a
> vendor with somewhat confidential info, and won't allow any changes
> (presume locked) directly to it.
>
> Thanks,
>
> T

Either there is an error in the formula or the cell is formatted as text

[Gord Dibben]

Sounds like the cell was pre-formatted as Text.

Format to General then hit F2 + ENTER


Gord Dibben MS Excel MVP

On Mon, 12 Jun 2006 09:15:17 -0500, tmurcer
<[email protected]> wrote:

>
>I am trying to run a VLOOKUP, but when I press enter the formula stays
>on the screen. No typical errors (i.e. #N/A), it just stays locked.
>Any suggestions?
>
>Note: the sheet that I am referencing for the lookup came from a vendor
>with somewhat confidential info, and won't allow any changes (presume
>locked) directly to it.
>
>Thanks,
>
>T