vLookup returns formula and not result
 

The formula returns a result in the wizard but will not display it on the
worksheet? No luck with the Show Formula button.

vLookup returns formula and not result
 

The cell was formatted as Text when you entered the function.
Just re-formatting is not enough; format as number or General AND re-enter
the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cmc4" wrote in message
...
The formula returns a result in the wizard but will not display it on the
worksheet? No luck with the Show Formula button.

vLookup returns formula and not result
 

If both the formula bar and the cell display the formula rather than the
result, then the cell was formatted to Text before the formula was entered.
Clear the cell and re-enter the formula
--
Gary''s Student - gsnu200903


"cmc4" wrote:

The formula returns a result in the wizard but will not display it on the
worksheet? No luck with the Show Formula button.

vLookup returns formula and not result
 

Excellent. Work perfect. One more Niek, to keep the formula static besides
the
lookup value:

=VLOOKUP(C2,Sheet1!A2:D326,1,FALSE)

"Niek Otten" wrote:

The cell was formatted as Text when you entered the function.
Just re-formatting is not enough; format as number or General AND re-enter
the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cmc4" wrote in message
...
The formula returns a result in the wizard but will not display it on the
worksheet? No luck with the Show Formula button.

vLookup returns formula and not result
 

Not sure what you mean, but maybe this:

=VLOOKUP(C2,Sheet1!$A$2:$D$326,1,FALSE)

You can easily change to absolute references by pressing F4 when you are
entering or editing the cell references.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"cmc4" wrote in message
...
Excellent. Work perfect. One more Niek, to keep the formula static
besides
the
lookup value:

=VLOOKUP(C2,Sheet1!A2:D326,1,FALSE)

"Niek Otten" wrote:

The cell was formatted as Text when you entered the function.
Just re-formatting is not enough; format as number or General AND
re-enter
the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cmc4" wrote in message
...
The formula returns a result in the wizard but will not display it on
the
worksheet? No luck with the Show Formula button.

vLookup returns formula and not result
 

On Thursday, September 17, 2009 at 5:09:01 AM UTC+10, cmc4 wrote:
The formula returns a result in the wizard but will not display it on the
worksheet? No luck with the Show Formula button.

There are a couple of reasons that this could be happening.
Check out this blog post which details the potential reasons.

http://www.excelvlookuphelp.com/why-...ot-the-result/