Move the Ranks in Row 3 above the Product Codes in Row 2. Then the hlookup will work on Sheet1.