Originally Posted by BobBridges

I hardly ever use the True option for the fourth VLOOKUP argument, kruiser; almost always—well, always that I can remember—I'm looking for exact value, so I plug in 0 there. ("0" takes up less space than False, but means the same thing.)

So I had to look up what happens when you use True, and it says the table you're looking at—Table4, in C16 in your sample—must be in ascending order. You have it in descending. I'm guessing that Excel reasons this way: Starts at S4. The value in S4 is 100". The value of C15 is 60.5. Is C15 greater than S4? No, it's less. Well, that's it; since all the rest of the values in Table4 must be 100 or greater, then clearly no value in Table4 will fit the search. So it returns #N/A.