=offset(sheet2!$C$1,Match(Sheet1!$A$1,Sheet2!$C:$C ,0)-1,0)

would give you the found cell

=offset(sheet2!$C$1,Match(Sheet1!$A$1,Sheet2!$C:$C ,0)+7,0)
would be 8 cells below (depending on how you count the 8)

You could also use Index
--
Regards,
Tom Ogilvy

"Steve" wrote:

Hi. Can I write a formula that will scan all fo Sheet2, with a lookup
value in cell Sheet1!A1, and return the value in the cell that is 8
rows directly below the cell where the lookup value is found?

Thanks!