use a result of function as cell location?

**simkhovich** · 09-21-2014, 12:50 AM

I have a cell with a function "=(((COUNT(A:A))*G17)/100)" the result is 3 for example but can change at anytime from other data what i want it to do is insert the result as a address so "J3" and have it change if the original function gives a different result.

**FDibbins** · 09-21-2014, 12:55 AM

Hi, welcome to the forum

To use text as a reference in a formula, you would use the INDIRECT() function. Something like....

=INDIRECT("J"&COUNT(A:A)*G17/100) (you dont need all those parentheses)

**simkhovich** · 09-21-2014, 01:14 AM

thanks got it working

**FDibbins** · 09-21-2014, 01:23 AM

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)