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
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
Maybe you can do:
where 1 is the value you want to replace it withRange([=CELL("Address",INDEX($AM$100:$AM$874,MATCH($S$29,$AA$100:$AA$874,0)))]) = 1
This worked like a charm from what must be a professional....I thank U and bid you a wonderful Christmas season
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks