How To Use VLOOKUP and IFERROR in Excel
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!
Видео How To Use VLOOKUP and IFERROR in Excel канала heyshirls
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!
Видео How To Use VLOOKUP and IFERROR in Excel канала heyshirls
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
INDEX MATCH Explained (An Alternative to VLOOKUP)VLOOKUP Exact Match with #N/A erros to fixAdvanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)How to use Excel Index Match (the right way)Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)Excel - IFERROR, IF, IF(AND, IF(OR10 Super Neat Ways to Clean Data in Excel15 IF Statement Examples in Excel - Simple to Advanced - Workbook IncludedIntroduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)Learn Vlookups in 7 Minutes (Microsoft Excel)Lock Cells and Protect Sheets in ExcelVlookup Magic 😮 Trick - Vlookup नहीं Smart Vlookup 👌 सीखो अब..Advanced Excel - VLOOKUP BasicsCreate Multiple Dependent Drop-Down Lists in Excel (on Every Row)How to Correct #N/A Error Messages for VLOOKUP Function in ExcelNesting VLOOKUP and IFERROR Functions | Everyday Office 023Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)7 Ways to Use Vlookup in ExcelExcel If Formula - Nested If AND OR FunctionsMS Excel - VLookup with Exact Match