How to Use the Excel 2007 VLookup Function

Watch the full course at http://SimonSezIT.com
In this video, we show you how to use Excel 2007 Vlookup function, also known as the Vertical Lookup function. This is considered the workhorse of all Excel 2007 lookup functions. This video and many more are available at www.SimonSezIT.com

Category:

Science & Technology

Tags:

• Excel
• 2007
• VLookup
• Vertical
• Lookup
• functions
• Functions
• Office
• Tricks

[TheChainslugger]

nice tutorial it's a pity when screwed up the exam just because forgot this kind of thing,anyway could you show me the combination for if function and value lookup?I'm new in here so I haven't seen whether you have posted or not.thx

[talentnts]

thank u,

[mtaj1981]

Thanks for the Vid. Helped me out.

[jigargpandya]

thanks,it has saved my many hours :)

[one4all1000]

Couple things you didn't mention, that the first column in your table array needs to be your lookup value, and second that if that first column isn't sorted or it’s sorted in descending order then the range lookup needs to be FALSE.

[dnbambi]

cheeeers!

[otiebaby]

thank you!!

[fayaz3raj]

thanks, really helpful

[ifuckednatalietran]

fuck i wish i watched this video 5 years ago. i could have easily have passed my vlookup exam

[12345raja12345]

Thanks...