Finding Named Range Name Based on a cell found within that range.

you say the named ranges are contiguous - are the values in col F or are the headers the only values in F ? (ie are they easy to differentiate ?)