Return value of cell address in column to right or left of a given cell address

Return value of cell address in column to right or left of a given cell
address

I'm using the below formula to return the address of values from sheet2
that match my value in sheet1:
=ADDRESS(MATCH(C18,Sheet2!C:C,0),3)
If the returned result in sheet1 cell E19 is (sheet2)"$c$8" (and not
null), then I would like to find what value is in sheet2 "$h$8".