Past Special

Dear Team,

We are trying to use past special option while using vlookup and it is not working.

 S. No	N	COMP	COMPONENT	DESCP	
21	1	510614	510610201	BRAZING	#VALUE!
25	1	510636	510630201	BRAZING	#VALUE!
26	1	510636	510620201	BRAZING	#VALUE!

[erAck: edited to make that resemble a table… (select and Ctrl+K which indents by 4 spaces)]

And how are you trying to use paste special while using VLOOKUP? What result are you expecting by doing what action, “not working” is not a description.

Please upload your ODF type sample file here.