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

See how to use an Approximate Match VLOOKUP function and lock the cell references that you can copy it down an entire column. See Absolute Cell References and Relative Cell References.

Category:

Science & Technology

Tags:

• Excel
• VLOOKUP
• Absolute
• Cell
• References
• and
• Relative
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[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)

[leonelparralopez2468]

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

[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!

[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]

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!