VLOOKUP
Dynamic Report With Power Query and VLOOKUP – Approximate Match
When you want to create a dynamic report from multiple sources and you need an approximate match, If the VLOOKUP Cannot get the job done, Then Power Query will come for rescue. In this tutorial I crea...
From Data to Dynamic Dashboard … All In One Dashboard with Form Controls
Complete Course on Dashboards Creation with form controls If you want pre-build templates with dashboards, check out Simple Sheets. Having a la...
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...
Combining Two Excel Workbooks Using VLOOKUP Function
INTRODUCTION If you have 2 workbooks which you would like to combine, VLOOKUP function is your best friend in this case. Especially, it is extremely useful when one of the lists is not full and simply...
