match and offset
Thanks, everybody! I'm sure this will help... Just a few questions,
please. Regarding the OFFSET function... The problem I'm having is
that I can't seem to make A1 in your example equal to the result of my
MATCHCH function. In other words, I run into syntax problems when I
try to embed a MATCH. function in the OFFSET function. The resulting
equation in the example would be something like:
=OFFSET(Q1,A(MATCH(A1,Sheet1!C:C,O)-1,1)
but I can't get this to work.
As far as the INDEX function goes, I will experiment.
Thanks again!
|