Excel find in named range of more than 1 column?

[QuantBurner]

Hi,
in excel (ie without using VBA) is there a formula to see if a value is in a named range that consists of more than 2 columns? For instance, let's say I name A1:B6 "Fred". Cell B2 has the value 2 in it. In cell D4 I have the value 2, what formula would return TRUE that the value of D4 is in Fred?
Cheers

 

[Trouttrap2]

you can try =COUNTIF(Fred,D4)>=1

 

[QuantBurner]

Perfect! Thanks much!