I used Vlookup in a series of cells to populate them with values from another sheet. But now every time I try to copy and paste those values that I used the VLookup to get, instead of obtained the values, it just copies the Vlookup formula. Is there a way around this and to just copy the value that the vlookup fetched?
After copy, go to Edit > Paste Special and select Values and that will not copy the formula across.
After copying...
Go to Edit|Paste Special and select Values.... or right-click and select Paste Special...and select Values
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Perfect. That was easy. Thanks again guys.
axc0054,Originally Posted by axc0054
Please do not "hijack" threads.... you should start your own thread and if need be reference another thread with a link to it.
I did notice this is not the first thread you "hijacked" today.
Hijack huh? Never saw it that way, thank you for the heads up. I was trying to follow suit to a question a previous poster had made...no harm intended.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
bardschant 
Register To Reply
Bookmarks