Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My formula returns a result but the cell displays a zero? | Excel Worksheet Functions | |||
Function that returns symbols as formula result eg up/down arrow? | Excel Worksheet Functions | |||
why cond sum wizard returns diff result as when formula typed out | Excel Worksheet Functions | |||
IF Function returns result of formula | Excel Discussion (Misc queries) | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions |