Thank, Jim. But unless I misunderstand your point, this method would
only give me the row in column C of Sheet1 that has the contents of A1
of the current worksheet in it. What I need is a way to reference the
relevant cells in the same row. That is, the cells of row X that is
the result of the match function. Am I making a false assumption?