Bonkers Bill
Active Member
- Joined
- Feb 14, 2005
- Messages
- 347
Hi, i have made a formula to return a cell reference, but i can only get it to return the written possition and not the actual cell reference that can be used in a formula.
=INDEX(A67:AB67,MATCH(COUNT(A45:AB45)*2+3,A68:AB68,0))&44
This returns Q44 in the cell the formula is in and not the value of Q44,
Either the formula does not work in this way or it is where i put "these" in the formula, which i have failed to make work. Any ideas appreciated, cheers.
=INDEX(A67:AB67,MATCH(COUNT(A45:AB45)*2+3,A68:AB68,0))&44
This returns Q44 in the cell the formula is in and not the value of Q44,
Either the formula does not work in this way or it is where i put "these" in the formula, which i have failed to make work. Any ideas appreciated, cheers.