Named functions

[Alexander_Golinsky]

Hi all! I wrote a function with column() inside and named it. When i use this name it shows the result of calculation based on the cell where it was named and i need it to be relative! How can i fix it. Thanks in advance!!

[TMS]

Might help if you shared the function ...

[Alexander_Golinsky]

Thanks for replying!!

=MATCH(INDEX(Base_tickers,MATCH($A2,BASA!$A:$A,1)-1,COLUMN()-1),Col_with_IDs,0)

Names here are all named ranges

[Alexander_Golinsky]

sOLVED. wHEN DEFYING THE NAME FOR THE FUNCTION, IN "REFERRING TO" ONE NEED PUT ALL FORMULA INSIDE AND NOT THE CELL CONTAINING IN ORDER TO GET TO BE RELATIVE.