Excel Magic Trick #397: VLOOKUP Copied Down a Column (VLOOKUP Basics)

[leonelparralopez2468]

i still don't know how you filled down the values, what do i do?

[leldiite88]

your videos helped me a lot, thank you!!!

[ExcelIsFun]

You are welcome!

[5132abcd]

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

[ExcelIsFun]

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

[5132abcd]

@ExcelIsFun Thank you very much , i really appreciate your effort, i am trying to learn excel through your videos.

[ExcelIsFun]

I am glad that the videos hlep! My new book is just out: "Slaying Excel Dragons" ($19 at Amazon and other book sellers)

[vivomcv]

Thank you so much for this. I've been glaring at my spreadsheet wondering why something wasn't working. I'm kind of new to excel so far as writing formulas... thank you. This saved my brain.

[ExcelIsFun]

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!

[vivomcv]

@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. :)

[ExcelIsFun]

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!

[ayan6174]

thank you again, ExcelFun. That's a lot of help.

[ExcelIsFun]

You are welcome!!

[rbondy007]

You are very helpful and I hope you realise people do appreciate your efforts to help other, thanks again

[ExcelIsFun]

You are welcome!

[Mynotoar]

Freedom's right :P. I finally understand how VLOOKUP works now! Doubtless, when we move onto Excel in ICT, I'll be able to gloat. Well, at first I'll gloat, then I'll put my head in my hands and sigh as everyone comes up to me asking for help. That happened last lesson. Heh.

[ExcelIsFun]

No gloating!!! The point to being good at something is so that you can have fun while helping others with a smile!!

[freedomfighter84]

Man, you are great. Thanks very much.

You are very helpful.

[ExcelIsFun]

Just a gou having fun with Excel!!

[ExcelIsFun]

If you download the workbook it has some useful notes!