How to use the Vlookup Formula / Function in Excel
As a long-time computer consultant/trainer , I am often asked about the proper way to use the powerful Vlookup function in a formula in Excel.
The vlookup function has many purposes. It can be used to compare data between 2 sheets, or merge information from 2 or more sheets into one sheet. Another possible use of it would be to convert a number grade into the appropriate letter grade. You can use the Vlookup function to calculate the tax rate based on someone's salary. Perhaps you were filling out an order, and when you fill in the part number , you want the proper description and unit price for that part to fill in automatically. The vlookup formula can be used for all of these purposes and alot more.
The Excel vlookup formula can be a little complicated, but once you use it a few times, you will get used to it, and find many uses for it.
Here's a video I made to demonstrate how to use the vlookup formula / function in Excel :
If the video can't play in this forum , click the link below.
Excel Vlookup Formula
Hope this helps.
You can find over 300 Free PC training videos that I made at:
Free PC Training Videos
Please feel free to leave a comment, or to request a topic that you may want to see.
Thanks for watching!
No comments:
Post a Comment