VLookup MS Mojo
As I wrote last week, I have some bad juju in Microsoft. I get erroneous answers that are not errors sometimes if I do not sort the lookup table by the lookup value, even though I have used a "false" in the match column since I learned the function (12 to 15 years ago).
Also, I use the iserr and some of the other information functions to return information to the list of values created by the lookup. So, if I have a numeric value and add an if statement that returns an error or na to the column, I can insert a zero and use that for sudden death calculations. I.e., if a certain characteristic is not present for that row/field combination, the formula inserts the 0; I use it in a calculation and the values for that row do not go forward included in calculations for the decision or calculation operation I am performing.
