Emmanuel Odeyemi·1d agoMastering Excel: A Practical Guide to Pivot Tables and Lookup FunctionsIntroduction
InT3CHbyMaria Eloisa Pedro·Aug 25, 2025INDEX & MATCH in Excel: The Lookup Combo That Outsmarted VLOOKUPLearn why INDEX & MATCH is a better alternative to VLOOKUP in Excel, and how it simplifies lookups in dynamic datasets.A response icon1A response icon1
Adityamohiteakm·Aug 8, 2025Mastering Excel Lookups: A Complete GuideExcel’s lookup functions are powerful tools for searching, retrieving, and organizing data. Whether you are finding a price for a product…
Rachana·Jun 9, 2025Building CreataDB: Printing the Tree and Adding Lookup Functionality(4/n)Welcome to the fourth installment in our series on building CreataDB, an in-memory database server from scratch in C. Previously, we…
Abhinav D·Apr 9, 2025Difference between C# dictionary and LookupIn C#, both Dictionary and Lookup are used to store key-value pairs.
Leon Wei·Jan 18, 2025Excel Guide: Find Row Number for Matched Values(Originally published at Skills.ai)
InStackademicbyKevin Meneses González·Dec 25, 2024SQL in Excel: The Ultimate Tool to Transform Your Data AnalysisData analysis often feels like navigating a maze. Traditional Excel tools are powerful but can become cumbersome when dealing with large…A response icon1A response icon1
InData 100byAbdurrahman Elkhadrawy·Sep 14, 2024Enhancing Data Interactivity and Lookup FunctionsHello again! In this article I will talk about how we can use tools we are previously familiar with and take it up a notch to enhance our…
InLearning DatabyVanja Radic·May 15, 2024Keeping RANK Values in Tableau While Using FiltersA quick fixA response icon1A response icon1
Gaurav Dembla·Mar 6, 2024Anaplan Use-Case 3: Matrix-Style vs. Vector-Style Data GridOften, business users find it more convenient to review and input assumptions/drivers in a certain style. Once such way is matrix-style…
