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


--
tmurcer
------------------------------------------------------------------------
tmurcer's Profile: http://www.excelforum.com/member.php...o&userid=33806
View this thread: http://www.excelforum.com/showthread...hreadid=551013

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

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
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