Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wizard with Data Tracking template wont work in 2007 Chili_con_parmi Excel Discussion (Misc queries) 2 August 4th 09 02:53 PM
Vlookup function across data copied from various sources Scarlett Excel Worksheet Functions 1 June 24th 09 07:28 AM
Status Bar: SUM function doesn't work for numbers copied from web suriogl Excel Discussion (Misc queries) 4 August 27th 08 12:32 AM
Sort function won't work with copied sum totals JulieInFlorida Excel Worksheet Functions 1 June 23rd 08 10:07 PM
Why SUMIF functionality doesn't work for data copied from .csv fil snaik Excel Worksheet Functions 4 March 5th 08 04:11 PM


All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"