Paste values when using Vlookup

Hi members,

I have a problem,in one of my tables i using Vlookup formulas to take values from the table.

When i have a lot of data from other Excel files i need them Copy-Paste but i this case my Vlookup does't works.

Question is Vlookup when values pasted?

Thank you for watching my post,all this site is incredible.