vLookup returns formula and not result

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.
 
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)
 
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
 
C

cmc4

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

=VLOOKUP(C2,Sheet1!A2:D326,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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP source values are a formula result. Getting #N/A 7
Use TODAY() function as the criteria in a SUMIF formula 1
VLOOKUP displays formula rather than result Excel 2007 2
Using a vlookup to search multiple criteria for one result? 7
Multiple VLOOKUP in an IF statement 2
WordPad blocked content 2
Vlookup and return sheet name also 2
Drop down list control value in vba 2

Top