Re: [ExcelVBA] Excel VLookup - doesn't work

 

Thank you.  I have been wrestling with this for a while. 
 
Sharron

From: J. Parrish <adari.j@gmail.com>
To: ExcelVBA@yahoogroups.com
Sent: Wednesday, August 24, 2011 11:57 AM
Subject: Re: [ExcelVBA] Excel VLookup - doesn't work

 
Sharron,

There are two issues with you sample that would prevent a vlookup from
working.
First we need to make the look up value, in this case you claim
number, the left most column in your look up array. So we make the
claim column A and The ID column B on Claims 2. Then there are
trailing spaces in the claim number on claims one which we use the
clean and trim functions within our vlookup to clear up as follows.

=VLOOKUP(CLEAN(TRIM(C2)),List1OWS[#All],2,FALSE)

If necessary and And David will share a link with me, I can send you
the sample file back.

Hope this helps. :-)

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (16)

Recent Activity:

• New Members 4

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___