Perhaps example of formula(e) might help with possible solutions?

"Ian" wrote:

I have individually found addresses within my worksheet, however when I use
the address formula within another function (like a match function), it gives
me an invalid entry error.
Can address be nested? Is there another way to get the cell locations and
then nest them into a formula?
Any help would be great!