| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup function wont work for copied data
I have copied a table from another source. I am trying to do a vlookup for a
column against this copied table. However N/A is returned. I tried TRIM, CLEAN, nothing works. I re-entered a couple of entries of the table and the vlookup function worked fine. However is there a logic to this problem and how do I make sure that the vlookup works for the entire column? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wizard with Data Tracking template wont work in 2007 | Excel Discussion (Misc queries) | |||
| Vlookup function across data copied from various sources | Excel Worksheet Functions | |||
| Status Bar: SUM function doesn't work for numbers copied from web | Excel Discussion (Misc queries) | |||
| Sort function won't work with copied sum totals | Excel Worksheet Functions | |||
| Why SUMIF functionality doesn't work for data copied from .csv fil | Excel Worksheet Functions | |||
Threaded Mode
