Excel Reverse Address type of problem

[derek Masten]

I'm trying to figure out a way that I can search portion of a worksheet
for a value and have the result be the address of that cell. It seems
that Excel will only search an address and display it's value.
ANYONE???

 

[Chip Pearson]

Derek,

It depends on what you are actually trying to do, but the ADDRESS
function comes to mind.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"derek Masten >" <<[email protected]>
wrote in message
news:[email protected]...