May 26 2021 12:28 PM
May 26 2021 02:23 PM
VLOOKUP, unless you set the "range lookup" to FALSE or 0 will, if the column being used as reference is not sorted in alphabetical or sequential order, once it hits an "answer" that is beyond the desired one, will go back to the previous.
For example, you have entered =VLOOKUP("C",tablerange,2) but the table being referenced is arrayed
then you will get the values next to "B" i.e., 34
If on the other hand you write your formula as =VLOOKUP("C",tablerange,2,0) you'll get your desired result. That last little 0 (or the word FALSE) is critical