Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
vLookup returns formula and not result
6,216 views
Skip to first unread message
cmc4
Sep 16, 2009, 3:09:01 PM9/16/09
to
The formula returns a result in the wizard but will not display it on the
worksheet? No luck with the Show Formula button.
worksheet? No luck with the Show Formula button.
Niek Otten
Sep 16, 2009, 3:13:09 PM9/16/09
to
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)
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" <cm...@discussions.microsoft.com> wrote in message
news:0612650D-1B3C-4B2E...@microsoft.com...
Gary''s Student
Sep 16, 2009, 3:17:03 PM9/16/09
to
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
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
Sep 16, 2009, 3:21:01 PM9/16/09
to
Excellent. Work perfect. One more Niek, to keep the formula static besides
the
lookup value:
the
lookup value:
=VLOOKUP(C2,Sheet1!A2:D326,1,FALSE)
Niek Otten
Sep 16, 2009, 4:20:16 PM9/16/09
to
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" <cm...@discussions.microsoft.com> wrote in message
news:FAA198BE-BF57-4A88...@microsoft.com...
matt...@gmail.com
Feb 14, 2015, 6:49:52 AM2/14/15
to
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.
> The formula returns a result in the wizard but will not display it on the
> worksheet? No luck with the Show Formula button.
Check out this blog post which details the potential reasons.
http://www.excelvlookuphelp.com/why-is-my-vlookup-formula-still-showing-as-a-formula-and-not-the-result/
0 new messages