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.