Description:
I made a macro to copy table A and paste its values (paste special) into table B.
Those cells having a vlookup function with index>2 will not be copied.

I have attached a spreadsheet with a macro that copies the values from the table B (range AT18 BF247) into the table A on the left (range B18 N247).
The macro is activated by the button UPDATE. Look at the brown columns in table A on the right, press the button at B210 and look at the brown columns in table B. Those values whose origin have vlookup functions with indexes > 2 are missing. To check this bug, modify the indexes to 1 or 2, press the button and it will work.
(some cells in the brown columns are just values, =strings, etc, to check the hypothesis).

Steps to Reproduce:
1. OPEN THE ATTACHED DOCUMENT (ALLOW MACROS)
2. PRESS THE "UPDATE" BUTTON.
3. BROWN COLUMNS HAVE NOT BEEN COPIED IF THEIR ORIGIN HAVE A VLOOKUP FUNCTION WHOSE INDEX IS >2

Actual Results:
 BROWN CELLS IN ROWS 218 AND 227 ARE BLANK.

Expected Results:
 BROWN CELLS IN ROWS 218 AND 227 SHOULD HAVE THEIR VALUE COPIED.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Versión: 6.4.1.2 (x64)
Id. de compilación: 4d224e95b98b138af42a64d84056446d09082932
Subprocs. CPU: 8; SO: Windows 10.0 Build 18363; Repres. IU: GL; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES
Calc: CL