thankyou. I guesse I had been swapping values around enough, that I did not
realize that. not sure but think if I was referring to a cell with a value,
say: 56
then the following would be correct for that?: AND(ROW()=$BC$15,

either way, what I was trying to do is not working, may have to ask another
way.

is the match function a problem, since it looks for the first value,
desired, in a range?
if is a problem, do not think was able to pick past the first row for the
match function, for result to give a correct row number "away" from start of
range.. (make sense?) maybe match is not what should be using. (trying to
find first error "after" header row where same error appears, means would
never get past the header row). thanks

"Paul Lautman" wrote:

nastech wrote:
060716 MATCH function, exclusion question

hi, trying to use MATCH to find the first instance of items, but
want to exlude the top of document where there may be one or more of
the "instances- item erors"

the following does not work for receiving a #VALUE error.
e.g.:
AND(ROW()=$B$56,MATCH("dd",$D$1:$D$1303,0))


full example in use: is for hyperlink to first instance:

=HYPERLINK(IF(ISNA(MATCH("X",$D$1:$D$1303,10000)), "",
"#"&CELL("address",OFFSET(INDIRECT(SUBSTITUTE(SUBS TITUTE(CELL("address",W12),"$",""),ROW(),"")&
AND(ROW()=$B$56,MATCH("dd",$D$1:$D$1303,0))),$W$1 ,0))),"dd")


notes:
- remove AND(ROW()=$B$56, and following: ")"
- to work: W12, is column where want link to end up, 12 is row this
formula resides. thanks

$B$56 isn't a row!
ROW()=56
is how you should write something like that