Quote:
Originally Posted by Guloluseus
thanks Gebobs 
I had a playaround with vlookup, and reached about the same conclusion. I was having problems with the true/false at the end of the statement as it seemed counter intuitive, but your confirmation has givnm me a bit more confidence. Thanks |
I agree that it is counterintuitive.
I always use false because I am always looking for an exact match and don't want the equation to return a result that is not really for that value. Also, when using false, the lookup table does not have to be sorted.
Let me know if you need any more help.