Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup results in a number?
The results of a Vlookup function was a number versus the text in the cell.
Does anyone know why? -- Texas Wannano |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup results in a number?
How could we possibly know without your formulas and your data?
-- Kind regards, Niek Otten Microsoft MVP - Excel "Wannano" wrote in message ... | The results of a Vlookup function was a number versus the text in the cell. | Does anyone know why? | -- | Texas Wannano |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup results in a number?
First, what is the VLOOKUP formula you used?
And perhaps it is returning a different (incorrect) column ..parameter wrong? "Wannano" wrote: The results of a Vlookup function was a number versus the text in the cell. Does anyone know why? -- Texas Wannano |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup results in a number?
Col A: Text to lookup up
Col B: formula =VLOOKUP(A2,$C$2:$C$35,1,FALSE) Col C: Lookup List All 3-digit alpha (ABC, EXD, etc) -- Texas Wannano "Toppers" wrote: First, what is the VLOOKUP formula you used? And perhaps it is returning a different (incorrect) column ..parameter wrong? "Wannano" wrote: The results of a Vlookup function was a number versus the text in the cell. Does anyone know why? -- Texas Wannano |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup results in a number?
The Excel spreadsheet was an export from PeopleSoft. I open a new workbook
and copied the exact same data/formula and it worked perfectly...however, I still do not know what caused the error. Thank your for your effort. Regards, -- Texas Wannano "Niek Otten" wrote: How could we possibly know without your formulas and your data? -- Kind regards, Niek Otten Microsoft MVP - Excel "Wannano" wrote in message ... | The results of a Vlookup function was a number versus the text in the cell. | Does anyone know why? | -- | Texas Wannano |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup results in a number?
Now what was in A2, what was in $C$2:$C$35 (or the part that you expected the result from), what did you expect as result and what
was the actual result of your formula? We are nor clairvoyant! -- Kind regards, Niek Otten Microsoft MVP - Excel "Wannano" wrote in message ... | Col A: Text to lookup up | Col B: formula =VLOOKUP(A2,$C$2:$C$35,1,FALSE) | Col C: Lookup List | | All 3-digit alpha (ABC, EXD, etc) | -- | Texas Wannano | | | "Toppers" wrote: | | First, what is the VLOOKUP formula you used? | | And perhaps it is returning a different (incorrect) column ..parameter wrong? | | "Wannano" wrote: | | The results of a Vlookup function was a number versus the text in the cell. | Does anyone know why? | -- | Texas Wannano |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP not returning results | Excel Worksheet Functions | |||
Vlookup with two results | Excel Discussion (Misc queries) | |||
to sum up all value results from VLOOKUP | Excel Worksheet Functions | |||
See results of VLookup formula | Excel Discussion (Misc queries) | |||
how do you add vlookup results? | Excel Worksheet Functions |