Echo Back the Cell Location

[Davey Boy]

Is there a VBA routine that will echo back the cell
location based on the value in another cell ? For
example, consider the following

A B C D
1 101 110.5
2 102
3 103.9
4 104
5 110.5
6 121

I'm looking for the cell location for the value (110.5)
contained in cell C1 and place the returned location (A5)
in cell D1.
I tried a few things, but I'm just getting started in
VBA. Any help would be appreciated. Also, is it possible
to do the same task with worksheet functions ?

Thanks in advance,

 

[Frank Kabel]

Hi
with worksheetfunction:
="A" & MATCH(C1,A1:A10,0)