Excel Magic Trick #397: VLOOKUP Copied Down a Column (VLOOKUP Basics)
Loading...
8,060
Uploader Comments (ExcelIsFun)
Video Responses
This video is a response to Excel Lookup Series #1: VLOOKUP Function 1st Example
see all
All Comments (17)
-
i still don't know how you filled down the values, what do i do?
-
No money from videos. For 3 years and 1400 posted Excel How To Videos not one cent - just for free to make the world a better place!
-
@ExcelIsFun I will definitely look into it, man. I used this video and then another one a few hours later so you should absolutely get some of my money. :)
-
You are welcome! If you are new to Excel and need a book to learn from I just finished my first book and it's called "Slaying Excel Dragons"! 550 pages of EVERYTHING the beginner needs to know and only $19 bucks at Amazon!
Loading...
your videos helped me a lot, thank you!!!
leldiite88 6 months ago
You are welcome!
ExcelIsFun 6 months ago
Hi can you please tell me how to copy the data got through vlookup to another worksheet with out the formulas, i mean just the numbers without the formula, thanks
5132abcd 9 months ago
In Excel 2007 or later: Copy the cell, click on the cell you want to paste the copied item into, go to the Home Ribbon Tab, click on the Paste drop-down arrow, Clcik on "Paste Values".
In Excel 2003 or earlier: Edit Menu, Psate Special, Values.
The keyboard that works in all versions is:
Alt, E, S, V
ExcelIsFun 9 months ago
@ExcelIsFun Thank you very much , i really appreciate your effort, i am trying to learn excel through your videos.
5132abcd 9 months ago
I am glad that the videos hlep! My new book is just out: "Slaying Excel Dragons" ($19 at Amazon and other book sellers)
ExcelIsFun 9 months ago