hello,

i have function:

Function FindID(c As Variant, x As String, y As Range)

'c - file
'x - sheet
'y - value i'm looking for

s = "=INDEX('" & c & x & "'!C8:EX8,1,MATCH(" & y.Address(1, 1, xlA1, True) & ",'" & c & x & "'!C15:EX15,0))"

FindID = Evaluate(s)

End Function

i call this function as follows:

=IF(B31=".";"";IF(ISERROR(findid($C$5;$B$3;$D31)); "";findid($C$5;$B$3;$D31)))

or simply:

=findid($C$5;$B$3;$D31)

and value is not correctly calculated when i press F9 (i disabled
automatic caluculation). unless i press F9 again values are correctly
calculated

in automatic calculation i have to change some value twice..

why does this function work in this way?

regards