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.