Playback starts YouTube’s embedded player (privacy-enhanced mode).
Excel Tutorial: Using VLOOKUP and FORECAST to Look Up and Interpolate Values in a Table
ChannelOikoEco ProductionsDescription from the creator
I use Microsoft Excel a lot to quickly look up or estimate look up values (interpolate) from large datasets. Using the functions VLOOKUP and FORECAST will allow you to lookup values and interpolate them from your dataset. VLOOKUP only returns hard values - those values that are currently listed in the dataset. FORECAST has the ability of returning an interpolated value (in between 2 hard values in your dataset).
Enjoy!
Enjoy!
About this tutorial
OikoEco Productions published this 12:06 video tutorial on November 13, 2014. It has been watched 100,571 times on YouTube.
- Channel
- OikoEco Productions
- Category
- Education
- Duration
- 12:06
- Published
- November 13, 2014
- Views
- 100,571
- Likes
- 429
Tags
Share
This tutorial in other languages
- FRExcel Tutoriel: Utiliser RECHERCHEV et les prévisions pour les valeurs Look Up et interpoler dans une table
- ESExcel Tutorial: Uso de BUSCARV y las previsiones para buscar e interpolar valores en una tabla
- PTExcel Tutorial: Usando PROCV e previsão de olhar para cima e Interpolar valores em uma tabela
- ITExcel Esercitazione: Utilizzo VLOOKUP e previsioni al Valori Look Up ed interpolazione in una tabella
- DEExcel Tutorial: SVERWEIS und FORECAST nachzuschlagen und interpolieren Werte in einer Tabelle
- NLExcel Tutorial: Het gebruik van VLOOKUP en verwacht dat het Look Up en Interpolate Waarden in een tabel
- RUExcel Учебное пособие: Использование ВПР и ПРОГНОЗ искать и интерполировать значения в таблице
- PLExcel Samouczek: Korzystanie VLOOKUP i prognoza do wyszukiwania i interpolacji wartości w tabeli
- JAエクセルチュートリアル:表にルックアップし、補間値にVLOOKUPとFORECASTを使用して
- ARالتفوق التعليمي: استخدام VLOOKUP وتشير التوقعات الى بحث لأعلى وأقحم القيم في الجدول
- HIएक्सेल ट्यूटोरियल: एक तालिका में देखो ऊपर और अमान्य तरीके से मान को VLOOKUP और पूर्वानुमान का उपयोग करना
- IDExcel Tutorial: Menggunakan VLOOKUP dan PRAKIRAAN untuk Look Up dan Interpolasi Nilai dalam Tabel