+ Reply to Thread
Results 1 to 2 of 2

[solved] help webpage explaining how string values can cause problems in Vlookups

  1. #1
    Registered User
    Join Date
    08-14-2015
    Location
    Philadelphia, PA
    MS-Off Ver
    Office 365 for Windows
    Posts
    18

    [solved] help webpage explaining how string values can cause problems in Vlookups

    I was reading an instructional article here about vlookups: http://www.felienne.com/archives/3980 (I attached a screen shot of the portion that is relevant to my question)
    The author talks about how string data in the lookup value field can cause problems. When you are doing the binary lookup (in other words, the lookup that is not looking for an exact match), my understanding is that you have to have the "result" values sorted. So, why is the author talking about the lookup value column not being sorted? I thought that that column does not matter & that it's only the column with the result values that matter. I am assuming that my understanding of vlookup was wrong.
    Attached Images Attached Images
    Last edited by Silverthunder; 05-05-2016 at 03:20 PM.

  2. #2
    Registered User
    Join Date
    08-14-2015
    Location
    Philadelphia, PA
    MS-Off Ver
    Office 365 for Windows
    Posts
    18

    Re: help webpage explaining how string values can cause problems in Vlookups

    Nevermind, I found some information that the data needs to be sorted based on the lookup value. So, my original understanding was wrong.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replace vlookups with values after a certain date.
    By jimcuk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-21-2015, 03:18 PM
  2. Pass entire HTML source for webpage to string using Excel VBA
    By stuht in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2013, 09:48 AM
  3. Get HTML Code into String from Newly clicked webpage (i.e. URL doesn't change)
    By bcbc123 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-11-2013, 11:39 PM
  4. Replies: 5
    Last Post: 11-08-2012, 03:38 PM
  5. Vlookups with multiple values for same ID
    By Daniel1986 in forum Excel General
    Replies: 9
    Last Post: 06-22-2012, 03:36 PM
  6. problems with VLOOKUPS?
    By childothe1980s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2006, 01:05 PM
  7. Problems with line tool when saving as a webpage
    By Phil BUtler in forum Excel General
    Replies: 0
    Last Post: 03-14-2005, 10:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1