Three Uses for Excel’s VLOOKUP Formula

July 13th, 2021

If you have two tabs on Excel with the same samples but have different dimensions and metrics, combining the 2 tabs means manually taking the data from one table, looking for the correct sample to put the data into on the other, and then inputting the content per each value. With a vlookup, you can just autofill the fields for quicker data entry! Learn how to do this vlookup hack and other vlookup tips on our 3 Minute Thursday video. See the video below.

Three Great Suggestions for Using Excel’s VLOOKUP Formula – in 3 minutes, more or less!

For our latest course dates showing you how to do all this and more, see our face-to-face Excel Advanced course HERE and the live online session HERE.

To inquire about a closed course just for your personnel, send us a query here.

0 Responses to Three Uses for Excel’s VLOOKUP Formula

    Leave a Reply

    Your email address will not be published.

    IT Training AND Courses
    We are here to help you work smarter with your IT tools. Whether it's for business, work or fun, our services will increase your productivity and minimise your stress. Look around for info about our services and courses, dates, bookings, help desk, resources and more.
    • Analysis of your needs.
    • Face-to-face or live, online.
    • Our training rooms or yours.
    • Extensive training manuals.
    • Help desk support.
    Our corporate video
    Call (02) 6041 2711