XLOOKUP
Impressive Chart with Chart Title Drop List
Download the eBook Table of Contents Switching Charts with A Drop-Down List 3 1. Creating a data preparation table 3 Creating a drop list for the different months 3 Creating row labels for the ...
Dependent Drop List – No Preparation Table
Creating dependent Drop List without Any Preparation Table What is a dependent drop List? It’s a drop List where the items change based upon your selection from another drop List. In our example we ha...
Excel Dice Rolling Game
Roll the Dice… Using Functions and Macro Dice rollers are needed for lots of games … If you want to have one always at hand then nothing can match the Excel dice roller which allows you to...
XLOOKUP vs INDEX & MATCH for a Dynamic Chart
Xlookup to create a Dynamic Chart First time ever… Chart Title drop List In this tutorial I show you how to use the new XLOOKUP function to create a dynamic chart in Excel that switches data depending...
