The above example demonstrates my favorite but not the only possible way to do a case-sensitive Hlookup in Excel. If you are curious to know other techniques, please check out this tutorial:4 ways to do a case-sensitive Vlookup in Excel. I think you won't have any problems with rebuildi...