Excel Lookup Tutorial Videos

Httpbitlytech4excel learn the basics of using microsoft excel including the anato.

Excel lookup tutorial videos. In other words it allows you to find look up a value from one column of data and returns its respective or corresponding value from another column. If you like this video heres my entire playlist of excel tutorials. Xlookup explainedxlsx 3683 kb. Want more excel videos.

Learn to use the vlookup in this free excel video tutorial. This video explains how to use the vlookup function in excel to compare two table and pull matching data how to vlookup in multiple sheets with multiple cr. The formulas will only work if you are on a version of excel that supports xlookup. So as an example ill enter part numbers the thing i know and find out prices the thing i dont know.

Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. Download the excel file. Vlookup works a lot like a phone book where you start with the piece of data you know like someones name in order to find out what you dont know like their phone number. You can use the if function to check whether a condition is met and return one lookup table if true and another lookup table if false.

Select cell e4 and enter the vlookup function shown below. Create two named ranges. Currently a portion of users on the office 365 insiders fast channel. Here is the file i use in the video.