"Larry" wrote
can I locate the cell address with only the cell value.

But wasn't this was your original question for which you've already got 2
responses to try ?

The only info I would know is the column (eg. column A).
I am trying to use this to locate a range in another formula.

This is perhaps too vague for a meaningful response to be given.
One pointer that you seem to be hinting at is the use of INDIRECT. Try
providing more details on your set-up, some sample data, the expected
results, present formulas which you're using, etc, and I'm sure that you'd
receive better responses.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----