formula displays rather than result??? 2

[shelron]

I am doing a vlook up, but the formula is displayed not the result???

Everything is formatted as text, save the file as a 97/2000/2002 excel file.

I am working in 2002

I have other formulas on the same sheet that work fine.

What's up?

Thanks, Ron

 

[carrr]

Obvious fix first...do you have an = sign in front of the formula. (Have to ask...)

 

[shelron]

=VLOOKUP(B2,'NEWEST DUMP2-26'!A:C,3,FALSE)



yup,,,

 

[xlbo]

check the format of the cell - if text, change it then hit F2 and then return

Check to see whether there is a ' in front of the = sign
This won't be visible in the cell but will in the toolbar
If it is there, you've probably got "Transition Navigation Keys" ticked in tools>options>transition Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur

 

[shelron]

Interesting observation,

I just noticed that when I try to copy the formula down the column, it copies it exactly, like it is an absolute reference

 

[shelron]

well carr, You were on the right track,,

There was some kind of space or novisible character in front of the equals sign,.

I deleted it and now it work fine,

thanks all, Ron