You should put the Match in its own cell if you are going to use it more
than one time., as it sounds you are. Why make Excel do the same Match many
times? Better to do it once and reference that.

A(MATCH(A1,Sheet1!C:C,O)-1

Get rid of the beginning "A".

--
Jim
"Jaybird" wrote in message
...
| 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!