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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup function wont work for copied data
Try a wildcard like
=VLOOKUP("*" & lookupvalue & "*",array,column,type) If this post helps click Yes --------------- Jacob Skaria "Scarlett" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup function wont work for copied data
The other source is what?
You could have some non-breaking spaces which CLEAN and TRIM won't find. EditReplace What: Alt + 0160 With: nothing Replace all. Note: hold the Alt key and type 0160 on the NumPad, not above the qwerty keys. If no joy go to Chip Pearson's site and download his cellview add-in to find out what's in the cells. http://www.cpearson.com/excel/CellView.aspx An indispensable tool if bringing in data from the Internet Gord Dibben MS Excel MVP On Tue, 23 Jun 2009 19:16:02 -0700, Scarlett wrote: 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? |
Reply |
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 |