VLOOKUP between 2 workbooks

[max_max]

Hi I have attached 2 workbooks.
1) DISTINTA BASE MAXMAX
2) PROVA DISTINTA
in PROVA DISTINTA there is a VLOOKUP formula: VERT that searches for data in DISTINTA BASE MAXMAX
I do not know if the formula is correct.
I have a problem I do not understand why if I insert new values in DISTINTA BASE MAXMAX then in PROVA DISTINTA it does not find them.
This happens from row 85 onwards.
A help?
I hope I explained myself.
max

[TMS]

I suspect you just need to refresh/update your links to the second file.

I downloaded both your files and updated the source file for the link and your formula seems to work for me.

[max_max]

It does not update with update all

[max_max]

I created with the recorder:

Please Login or Register  to view this content.

but gives error:

error 1004
object updatelink method failed