When any cell in row 19 (eg K19) equals X I want the cell in row 25 3cells before K19 (i.e. H25) to

M

Max

Re: When any cell in row 19 (eg K19) equals X
I want the cell in row 25 3 cells before K19 (i.e. H25) to equal Y.

One way to get it done ..

In A25:
=IF(ISNA(MATCH("X",19:19,0)),"",IF(MATCH("X",19:19,0)<4,"",IF(COLUMNS($A:A)+3=MATCH("X",19:19,0),"Y","")))
Copy right across to IV25

Above of course, assumes that there's only a single "X" within row 19 at any
time. If you got more "X"'s in row 19, it'll return only the result for the
1st one (from the left)

p/s: You should always post your question in the message area. The subject
line is just that -- a brief liner hinting at the question -- it's not meant
to be the posting.
 
Q

quiettechblue

Max [email protected] left this in microsoft.public.excel:
Re: When any cell in row 19 (eg K19) equals X
I want the cell in row 25 3 cells before K19 (i.e. H25) to equal Y.

One way to get it done ..

In A25:
=IF(ISNA(MATCH("X",19:19,0)),"",IF(MATCH("X",19:19,0)<4,"",IF(COLUMNS($A:A)+3=MATCH("X",19:19,0),"Y","")))
Copy right across to IV25

Above of course, assumes that there's only a single "X" within row 19
at any time. If you got more "X"'s in row 19, it'll return only the
result for the 1st one (from the left)

p/s: You should always post your question in the message area. The
subject line is just that -- a brief liner hinting at the question --
it's not meant to be the posting.
Click to expand...

A simple IF(X=K$19, X,"") ought to do the job (if i got the order of the
arguments right). Then spread it across the columns of interest.
 
Top