pm wrote:

thank you :)

but i have one more question

i changed my function:

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

'c - file
'x - sheet
'y - value i look for

s = "=INDEX('" & c & x & "'!C8:EX8,1,MATCH(" & y.Value & ",'" & c & x & "'!C15:EX15,0))"
FindID = Evaluate(s)

End Function

and formula:

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

and result #N/D!