match and offset
Well, maybe I misunderstood you. My example returned the value in R10
(assuming the Match in A1 returned 10):
=OFFSET(Q1,A1-1,1) = R10
and therefo
=OFFSET(Q1,A1-1,2) = value in S10
=OFFSET(Q1,A1-1,3) = value in T10
etc.
If that's not what you want then I misunderstood you, sorry. If it is then
try a few examples for yourself to get a feel for it.
--
Jim
"Jaybird" wrote in message
...
| 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?
|