| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup function across data copied from various sources
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 | |||
| Sources Used in Data Validation | Excel Worksheet Functions | |||
| I believe the rate function is broken in Excel 2003.... I can't verify this with other sources though | Excel Discussion (Misc queries) | |||
| Vlookup for two lists from different sources | Excel Discussion (Misc queries) | |||
| 2 sources needed for vlookup | Excel Discussion (Misc queries) | |||
| Charts different data sources | Charts and Charting in Excel | |||
Threaded Mode
