Hey guys!

I made this video for a data journalism assignment at uni. This is a basic tutorial on how to use the VLOOKUP and IFERROR function in excel. The VLOOKUP function allows you to locate data in tables and large datasets by using a specific value as a reference point. On the other hand, the IFERROR function is useful for customising a response when Excel evaluates an error (in this case, #N/A errors that appear when the VLOOKUP function cannot find the value you have specified).

Hope you find this tutorial helpful!

свернуть