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.
Bookmarks