hey. i want to make a formule using index, which will get value from sheet. it wouldnt be a problem, but i have a lot of sheets, all of them called by names and i want formule to get sheet name from a cell. sth like :
i dont know how to get name from cell, for example a60. "a60" doesnt work, is it possible?=INDEKS('name'!$AD17:$AD17;$H$1;1)
Bookmarks