Vlookup will not retrun value

  • Thread starter Thread starter Dave Shultz
  • Start date Start date
D

Dave Shultz

I have a very simple formula

=VLOOKUP(M3,Days!$A$5:$I$28,9,FALSE)

When I change M3 to N3 and hit enter, I see
=VLOOKUP(N3,Days!$A$5:$I$28,9,FALSE) displayed. How do I get this to retun
the value and not the text string?
 
Format the cell as General (or anything but text).
Then hit F2, then enter (excel will see that it's a formula)
 
Hi,

Maybe the cell is formatted as text. Select the cell format as general then
tap F2 and ENTER
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top