| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup not found
My vlookup statement is not finding values that I can confirm exist in the
array. The problem has something to do with the format, I assume, because if I re-key the searched item, it works. I'm looking up 4-digit numbers produced from a report that is dumped into Excel. I've tried reformatting the data to numeric, but that doesn't work. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup not found
Try to run Data|Text to Columns on the data you have dumped into Excel.
Othwerwise, experiment with: =VLOOKUP(LookupValue&"",LookupTable,ReturnRangeInd ex,0) BadgerDave wrote: My vlookup statement is not finding values that I can confirm exist in the array. The problem has something to do with the format, I assume, because if I re-key the searched item, it works. I'm looking up 4-digit numbers produced from a report that is dumped into Excel. I've tried reformatting the data to numeric, but that doesn't work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP Problem | Excel Discussion (Misc queries) | |||
| Vlookup data wrong if the small value found are same | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| ISNA VLOOKUP any data prefixed with a "C7" cannot be found? | Excel Discussion (Misc queries) | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Linear Mode
