![Tiger Spreadsheet Solutions](/img/default-banner.jpg)
- 461
- 8 691 998
Tiger Spreadsheet Solutions
United Kingdom
Приєднався 11 вер 2012
Welcome to Tiger Spreadsheet Solutions where our mission is simple: to move you from Excel frustration to Excel control.
Whatever you are struggling with in Excel: big datasets, formula-building, pivot tables or automating boring processes, we are here to help.
Our aim is to help you master Excel formulae, Excel VBA and important tools such as Power Query to help you gain Excel clarity and control. Need to nail the report, presentation or job interview with some killer Excel work? You're in the right place!
Whatever you are struggling with in Excel: big datasets, formula-building, pivot tables or automating boring processes, we are here to help.
Our aim is to help you master Excel formulae, Excel VBA and important tools such as Power Query to help you gain Excel clarity and control. Need to nail the report, presentation or job interview with some killer Excel work? You're in the right place!
THE ONE FORMULA I WISH EXCEL HAD (+How To Build It Yourself!)
To ‘look up’ a value in a spreadsheet is something professionals do all the time. Think about looking up somebody’s name in the telephone directory: you find their name, then look across to get their phone number. In Excel language, we might say ‘find the value, then return a value from the same row, but in a different column.’
💻DOWNLOAD THE EXCEL FILE (CODE INCLUDED!)
tinyurl.com/yc443aye
Excel provides formulae to get this basic job done: VLOOKUP, HLOOKUP and, more recently, XLOOKUP. I find people love conquering these formulae for the first time, particularly VLOOKUP which seems to define you as an advanced Excel user: ‘Wow, you can do VLOOKUP?!’
So where does DLOOKUP fit into this? Spoiler alert: this formula doesn’t actually exist in Excel … but, I wish it did. And, I’m going to show you how to make it in just a few minutes.
🔥WATCH NEXT: Excel VBA For Beginners (1 MILLION VIEWS!)
ua-cam.com/video/78GvLEAZecs/v-deo.html
🔥WATCH NEXT: Excel VBA Building Blocks
ua-cam.com/video/O6zfwuCr1cg/v-deo.html
With Microsoft adding new formulae all the time, many of which, in my view, add only marginal value, I’m surprised this function has been overlooked. DLOOKUP refers to a ‘double’ lookup: looking up values in not one, but TWO columns in a dataset.
To return to the telephone directory example: suppose I wanted to look up ‘Luna’. But, there are multiple Lunas in this telephone directory. Specifically, I want Luna who lives in Haminjaland. So, I need to look up ‘Luna’ in the name column, and ‘Haminjaland’ in the location column. It’s a double lookup. Why does this formula not already exist in Excel? It should!
It’s something I’ve been asked countless times in my career as an Excel content creator, lecturer and consultant. And, until now, I’ve not made a video on it. Formula-based solutions are possible, but horrendously complicated and beyond the reach of the average professional. My solution is clean and simple - but does call on VBA code to make the magic happen.
In this video, I show you how to quickly achieve DLOOKUP functionality with what’s called a ‘custom function’ in Excel VBA. Yes, VBA allows you, in effect, to create your own formulae, following whatever logic you need in your situation. If you need to look up values in two columns in Excel, you’ll love the demonstration. Make sure you download the Excel download file and work along with me.
Yes, this solution, being VBA-based, applies only to desktop Excel. If you’d like to see a cloud-based version of the DLOOKUP formula, created using Office Script in Excel 365, let me know in the comments below. If there are enough requests, I’ll happily put the video together.
In the meantime, I hope you enjoy getting to know the DLOOKUP formula and experience one or two ‘punch-the-air’ moments along the way.
📺WATCH NEXT
🔥Excel VBA For Beginners (1 MILLION VIEWS!)
ua-cam.com/video/78GvLEAZecs/v-deo.html
🔥Excel VBA Building Blocks (MASTER VBA IN 6 PARTS)
ua-cam.com/video/O6zfwuCr1cg/v-deo.html
🔥Excel VBA To Move Data Around A File (INSTANTLY!)
ua-cam.com/video/Z62yORhPr3Q/v-deo.html
🔥Excel VBA Long Form Tutorial (COMPLETE APPLICATION BUILD)
ua-cam.com/video/igeLpQtDBUE/v-deo.html
💻DOWNLOAD THE EXCEL FILE (CODE INCLUDED!)
tinyurl.com/yc443aye
Excel provides formulae to get this basic job done: VLOOKUP, HLOOKUP and, more recently, XLOOKUP. I find people love conquering these formulae for the first time, particularly VLOOKUP which seems to define you as an advanced Excel user: ‘Wow, you can do VLOOKUP?!’
So where does DLOOKUP fit into this? Spoiler alert: this formula doesn’t actually exist in Excel … but, I wish it did. And, I’m going to show you how to make it in just a few minutes.
🔥WATCH NEXT: Excel VBA For Beginners (1 MILLION VIEWS!)
ua-cam.com/video/78GvLEAZecs/v-deo.html
🔥WATCH NEXT: Excel VBA Building Blocks
ua-cam.com/video/O6zfwuCr1cg/v-deo.html
With Microsoft adding new formulae all the time, many of which, in my view, add only marginal value, I’m surprised this function has been overlooked. DLOOKUP refers to a ‘double’ lookup: looking up values in not one, but TWO columns in a dataset.
To return to the telephone directory example: suppose I wanted to look up ‘Luna’. But, there are multiple Lunas in this telephone directory. Specifically, I want Luna who lives in Haminjaland. So, I need to look up ‘Luna’ in the name column, and ‘Haminjaland’ in the location column. It’s a double lookup. Why does this formula not already exist in Excel? It should!
It’s something I’ve been asked countless times in my career as an Excel content creator, lecturer and consultant. And, until now, I’ve not made a video on it. Formula-based solutions are possible, but horrendously complicated and beyond the reach of the average professional. My solution is clean and simple - but does call on VBA code to make the magic happen.
In this video, I show you how to quickly achieve DLOOKUP functionality with what’s called a ‘custom function’ in Excel VBA. Yes, VBA allows you, in effect, to create your own formulae, following whatever logic you need in your situation. If you need to look up values in two columns in Excel, you’ll love the demonstration. Make sure you download the Excel download file and work along with me.
Yes, this solution, being VBA-based, applies only to desktop Excel. If you’d like to see a cloud-based version of the DLOOKUP formula, created using Office Script in Excel 365, let me know in the comments below. If there are enough requests, I’ll happily put the video together.
In the meantime, I hope you enjoy getting to know the DLOOKUP formula and experience one or two ‘punch-the-air’ moments along the way.
📺WATCH NEXT
🔥Excel VBA For Beginners (1 MILLION VIEWS!)
ua-cam.com/video/78GvLEAZecs/v-deo.html
🔥Excel VBA Building Blocks (MASTER VBA IN 6 PARTS)
ua-cam.com/video/O6zfwuCr1cg/v-deo.html
🔥Excel VBA To Move Data Around A File (INSTANTLY!)
ua-cam.com/video/Z62yORhPr3Q/v-deo.html
🔥Excel VBA Long Form Tutorial (COMPLETE APPLICATION BUILD)
ua-cam.com/video/igeLpQtDBUE/v-deo.html
Переглядів: 1 588
Відео
The 30 Excel Formulae You Must Know In 2024 (1-HOUR MASTERCLASS!)
Переглядів 882Місяць тому
With around 500 Excel formulae now available, which should you actually use, and which can you safely ignore? In this special one-hour Masterclass video, I take you through the 30 Excel formulae I'm using frequently in my real-life analytical projects, with the aim of moving you from Excel frustration ('not another formula!') to Excel control ('I know what to use in this situation ...') 📊DOWNLO...
Power Automate For Beginners
Переглядів 9193 місяці тому
How much of your Excel work are you doing ‘in the cloud’ these days? In Sharepoint, OneDrive or another shared platform? The world of online productivity feels exciting and certainly makes collaboration with colleagues easier. Perhaps you’re finding, however, that you spend a lot of time doing manual work in the cloud? It’s the same old jobs, just in a different environment that can feel alien ...
Excel VBA Beginner Tutorial 2024
Переглядів 1,4 тис.4 місяці тому
Excel data entry, formatting spreadsheets, report generation in Excel … these mundane tasks take up a huge amount of time in Excel and leave you feeling frustrated. Imagine If you could conquer your Excel frustration and automate these tasks by doing them … instantly. In this beginner video, I introduce to the magic of Excel’s programming language: Visual Basic for Applications or 'VBA.' 👉EXCEL...
Learn Excel's BEST Automation Tool In 15 Minutes!
Переглядів 2,4 тис.5 місяців тому
Are you tired or repetitive manual work in Excel? Of doing the same tasks again and again? Imagine if you knew how to do these tasks instantly. Imagine how much time you could save .. How much more you could get done. How much progress you could make in your career? In this video, I will introduce to the best easy way to automate manual work in Excel: Power Query 🔥DOWNLOAD FILES LINK tinyurl.co...
Learn Excel VBA From Beginner Level With This 5-Hour Excel VBA Project
Переглядів 6 тис.Рік тому
Learn Excel VBA From Beginner Level With This 5-Hour Excel VBA Project
Excel Dynamic Arrays 3 Years On - Have They 'Changed The Game'?
Переглядів 1,6 тис.Рік тому
Excel Dynamic Arrays 3 Years On - Have They 'Changed The Game'?
Learn The Easy Way To Transfer Data With Excel VBA In Around 5 Minutes! (WITH DOWNLOAD FILES)
Переглядів 2,7 тис.Рік тому
Learn The Easy Way To Transfer Data With Excel VBA In Around 5 Minutes! (WITH DOWNLOAD FILES)
How To Do What VLOOKUP Can't Do With OFFSET and MATCH
Переглядів 3,5 тис.Рік тому
How To Do What VLOOKUP Can't Do With OFFSET and MATCH
How To Categorise Numbers In Excel Using VLOOKUP
Переглядів 2,5 тис.Рік тому
How To Categorise Numbers In Excel Using VLOOKUP
How To Remove Spaces in Excel (When TRIM Doesn’t Work!)
Переглядів 18 тис.Рік тому
How To Remove Spaces in Excel (When TRIM Doesn’t Work!)
Complete Manual Excel Tasks In Seconds With THIS Excel Formula
Переглядів 2,3 тис.Рік тому
Complete Manual Excel Tasks In Seconds With THIS Excel Formula
Learn This Powerful Excel Formula Combination In Just 5 Minutes!
Переглядів 1,9 тис.Рік тому
Learn This Powerful Excel Formula Combination In Just 5 Minutes!
BEYOND THE MACRO RECORDER 2/4 - Loops In Excel VBA
Переглядів 1,4 тис.Рік тому
BEYOND THE MACRO RECORDER 2/4 - Loops In Excel VBA
How To Model Winning And Losing Streaks In Excel
Переглядів 2,6 тис.Рік тому
How To Model Winning And Losing Streaks In Excel
BEYOND THE MACRO RECORDER 1/4 - Dynamic Position Control With Excel VBA
Переглядів 1,9 тис.Рік тому
BEYOND THE MACRO RECORDER 1/4 - Dynamic Position Control With Excel VBA
Why Short Excel Formulae Are Better Than Long Excel Formulae (WITH PRACTICAL DEMO)
Переглядів 1 тис.Рік тому
Why Short Excel Formulae Are Better Than Long Excel Formulae (WITH PRACTICAL DEMO)
17 Excel Beginner Formatting Mistakes (AND HOW TO FIX THEM!)
Переглядів 2,5 тис.Рік тому
17 Excel Beginner Formatting Mistakes (AND HOW TO FIX THEM!)
How To Format Your Excel Spreadsheet Quickly And Professionally With 26 Excel Keyboard Shortcuts
Переглядів 2,9 тис.Рік тому
How To Format Your Excel Spreadsheet Quickly And Professionally With 26 Excel Keyboard Shortcuts
Excel Conditional Formatting Tutorial (FROM BEGINNER TO PRO!)
Переглядів 6 тис.Рік тому
Excel Conditional Formatting Tutorial (FROM BEGINNER TO PRO!)
How Excel Knows If You're Working On Mac Or PC 😮
Переглядів 542Рік тому
How Excel Knows If You're Working On Mac Or PC 😮
14 MORE Excel Formatting Tips (Make Excel Beautiful AGAIN)
Переглядів 18 тис.Рік тому
14 MORE Excel Formatting Tips (Make Excel Beautiful AGAIN)
Excel's Most Powerful Data Analysis Formula Explained In 5 Minutes
Переглядів 1,7 тис.Рік тому
Excel's Most Powerful Data Analysis Formula Explained In 5 Minutes
How To Combine Techniques Together In Excel VBA (Real-World VBA Task S3 P7)
Переглядів 888Рік тому
How To Combine Techniques Together In Excel VBA (Real-World VBA Task S3 P7)
How To Use Conditional (IF) Statements In Excel VBA (Real-World VBA Task S3 P6)
Переглядів 1,3 тис.Рік тому
How To Use Conditional (IF) Statements In Excel VBA (Real-World VBA Task S3 P6)
Get Started With Position Control In Excel VBA (Real-World VBA Task S3 P5)
Переглядів 1,3 тис.Рік тому
Get Started With Position Control In Excel VBA (Real-World VBA Task S3 P5)
How To Combine Two Loop Types In Excel VBA (Real-World VBA Task S3 P4)
Переглядів 1,2 тис.Рік тому
How To Combine Two Loop Types In Excel VBA (Real-World VBA Task S3 P4)
How To Build A Loop Within Loop In Excel VBA (Real-World VBA Task S3 P3)
Переглядів 1,4 тис.Рік тому
How To Build A Loop Within Loop In Excel VBA (Real-World VBA Task S3 P3)
How To Build A Loop In Excel VBA (Real-World VBA Task S3 P2)
Переглядів 2,5 тис.Рік тому
How To Build A Loop In Excel VBA (Real-World VBA Task S3 P2)