How do I combine VLOOKUP and OFFSET commands?

[Guest]

I have a data report dumped into Excel 2000. Each record has a number of
rows, but there is only one 'label' per record. I use a 'master sheet' to
combine all retrieved data.
For data on the same row as the label, I use VLOOKUP. However, for
information on a row lower than the label I need to use OFFSET. But the
OFFSET command needs to commence from the VLOOKUP'd cell.
My formula reads:
=OFFSET(VLOOKUP($A$1:$A$12,'[data sheet.xls]Sheet1'!$F$1:$W$68,3,0),1,0,1,1)
Any clues???

 

[Myrna Larson]

If you need to return data from a different row, then you should use the INDEX
and MATCH functions, i.e.

=INDEX($H$1:$H$12,MATCH(<target>,$F$1:$F$68,0)+1)