Simple But Stumped

B

Brian Keanie

Maybe it should be "Simple AND Stumped"

Attempting a very simple VLOOKUP formula and can't get the result in the
cell with the formula. =VLOOKUP(B4,testrange,2,FALSE).
The Fx or Function Arguments wizard shows me the correct answer but it does
not appear in the cell. Only the formula appears there.

I have used VLOOKUPS successfully before, but stumped here. Any hints or
solutions would be appreciated.

Regards
 
B

Bob Phillips

Is the cell formatted as text?

Also, check Tools>Options>View that the Formulas box is not checked.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Brian Keanie

Thanx Bob .... The cell is formatted as text and the T>O>V>Formulas is not
checked. The thing I can't quite get is that the wee wizard comes up with
the correct answer but it will not show in the cell.
 
P

Peo Sjoblom

Don't format the cell as text, format as general

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top