C
cmc4
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.
N
Niek Otten
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)
G
Gary''s Student
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
result, then the cell was formatted to Text before the formula was entered.
Clear the cell and re-enter the formula
C
cmc4
Excellent. Work perfect. One more Niek, to keep the formula static besides
the
lookup value:
=VLOOKUP(C2,Sheet1!A2
326,1,FALSE)
the
lookup value:
=VLOOKUP(C2,Sheet1!A2
326,1,FALSE)
N
Niek Otten
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.
=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.