lookup cell location

[joe smith]

Is there anyway to use the lookup function to give the
cell's adress of the value you want to look up instead of
the cell's actual value.

 

[Frank Kabel]

Hi Joe
see your responses in Excel.worksheet.functions
Frank
P.S.: please don't multipost as this scatters your answers and created
additional effort for the respondents