Quote Originally Posted by NBVC
Wouln't you know it? The word "High" in cell A1 of Sheet2 contains an extraneous space at the end. Please delete that space and then go back to sheet 1 and reselect "High" in the drop downs of column H.
LOL!! Typical, many thanks, as you rightly suggest, removing the space fixes it!