You can write a custom function similar to the following:
function contains (rngnm,cmpr)
for each cl in range(rngrm)
if cl.value = cmpr then
contains=true
exit function
end if
next
end function
http://HelpExcel.com
"Lee IT" wrote:
I need a formula function to check if a named range contains a certain entry.
A formula similar to: IF(DATA!Dave='computer',d16,""), where DATA is the
worksheet and Dave is the named range. But, rather than '=' I need a
function that checks if the range 'contains' a single or a number of
'computer' entrys in the range. The quantity of entrys is unimportant.
The Range:
The named range is a number of rows, of which the first column is merged to
contain the name of the person the rest of the data refers to. The data can
contain numbers, text or blank cells - relevant to the column headers.
I'm sure this must be possible!!!?