Jim Rech
5/7/2008 2:10:00 PM
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 therefore:
=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" <jaybirdster@gmail.com> wrote in message
news:01e3849c-cc73-4401-b20b-ede04e472103@x41g2000hsb.googlegroups.com...
| 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?