Any tips will be greatly appreciated.

Cheers!

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Max (E-Mail Removed) 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.
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---

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.