VBA Code to Replace Cell Value when Address found by Index/Match

[Rubert]

Can someone give me code to have this [=CELL("Address",INDEX($AM$100:$AM$874,MATCH($S$29,$AA$100:$AA$874,0))) ] to replace the value in the address it located. Works great, just need to replace the value in the located cell address.
Thanks, rubert