Blog Post for this video. https://www.businessprogrammer.com/what-does-vlookup-do/
This tutorial explains the advantages of the microsoft excel vlookup function and how to use vlookup definition to get things done.
How to use vlookup and how to best organise your spreadsheets and workbooks to make best use of vlookup.
Look over my shoulders as I use vlookup to match two sets of data together.
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://buymeacoffee.com/seanjohnson
☕
It is important to organise your spreadsheet data in a database manner, that is to say that you need to separate data from reports.
Mixing data and reports, meaning building consolidation reports by linking to other reports is an all to common error when building out complex spreadsheets.
If you organise your data so that you have dedicated areas that only hold data, and this data is in a tabular format with the identifying column being the first column, then it is easy to vlookups for your Excel reporting application.
It will also be very easy to manage your excel reporting system going forward.
This means that using vlookups can force you to build out spreadsheet systems that are very easy to mantain and be scalable.
Vlookup looks up the first column of a data range until it finds a match for the criteria item that was input as the first argument to the vlookup function, when it finds a match it then returns the value that is in the same or more likely a different column that is x columns away from the first column.
The value for x being the column offset that you specify as the third argument to the vlookup function.
Video Production
===============
Sony Camera: https://amzn.to/3mqyqfu
Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum
Microphones
---------------
Screen Casting: https://amzn.to/3a2TnHN
Microphone and Arm : https://amzn.to/3iwvL2S
Talking To Camera: https://amzn.to/3FqXI6b
Video Kit
-------------
Lights
Elgato video Lights: https://amzn.to/3sSK3xg
Background Light: https://amzn.to/3uTXyPh
Note Taking
--------------
Rocketbook reusable notebook https://amzn.to/3sSK3xg
#msexcel
DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.
0 Comments