If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|