| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup will not retrun value
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup will not retrun value
Format the cell as General (or anything but text).
Then hit F2, then enter (excel will see that it's a formula) Dave Shultz wrote: 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? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup will not retrun value
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. "Dave Shultz" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Retrun "" (blank) | Excel Worksheet Functions | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Hybrid Mode
