How can I change a text to a cell's address?

A

Antônio Sobral

I'm trying to use the down formula, but the result is a text. I need the
result from de cel, but the Excel don't understand the result as a cell's
addres. Some one could help me?

This is the formulas:
A5 = ENDREÇO(BDCONTAR(S8:S29988;S8;Fórmulas!H17:H18)+8;19;1)
P4 = CÉL("CONTEÚDO";A5) => Result "$S$495"

I need that the Excel understand the result as a cell's address.
PS.: My Excel is in portuguese.
 
Top