It would also be easier to maintain; you have a few rows and columns on a worksheet somewhere designating just what you said in your original post, and the VLOOKUP returns the correct percentage in one step, but if you change the ranges and/or percentages later then you need change only that one table and the rest of your references to it are updated automatically.