Paste values when using Vlookup

[ALEZI]

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.

[ratcat]

G'day,

Not knowing what formats or formulas you are using to copy and paste.

Try Paste Special > Values.

Copy what you need in the other sheet then when you pasting the values in right click on the cell then select 'Paste Special' then 'Values' then click 'Okay'.

[ALEZI]

Thank you for answer,

I was try this but it does't works when value are not from from table in sheet 1 or wrote by hand,when i took value from the table sheet 2 it does't work (i do this in the sample).

Maybe it doesn't work because in formula we arrayed which table is relevant,i don't know..i need to pasted values from other sheet but this values have to exists in the Table from sheet 1.

Thank you again..