+ Reply to Thread
Results 1 to 8 of 8

VBA Vlookup function returns wrong values

Hybrid View

  1. 05-28-2015, 05:27 AM #1
    alicelia
    alicelia is offline
    Registered User
    Join Date
    05-20-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    9

    Re: VBA Vlookup function returns wrong values

    Hi michson. Thanks for the reply. I have changed the code according to your corrections. This time the value changed to empty cell. The designated cells which are supposed to have values are empty and the remaining cells that exceeds the the table shows up with #NA. 

    
targetSheet.Cells(i, 11).formula = "=VLOOKUP(" & targetSheet.cells(i, 2) & ",sourceSheet!R16C1:R55C9, 9, False)"
    Also, I am not sure what I should set the variable to? Could you please give me some pointers to that? Sorry about this as I am quite new to VBA.
    Thank you very much.
    Last edited by alicelia; 05-28-2015 at 05:44 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] My Vlookup returns the wrong info
    By dstrdOne in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2013, 01:42 PM
  2. VLookup returns N/A or wrong value
    By vindieselgal in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-08-2011, 07:20 AM
  3. VLOOKUP returns wrong values
    By surfol in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-26-2011, 03:26 PM
  4. Row() function returns wrong row and more..
    By Kim in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2006, 09:14 PM
  5. [SOLVED] My Datedif function only returns 0's in the cell what's wrong?
    By Tom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-13-2006, 02:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1