Being able to use wildcard characters like * and ? in searches is something we are used to having. Now XLOOKUP allows you to do those types of searches in Excel.
Monthly Archives: February 2020
Excel XLOOKUP Actually Looks Down
Part Three - but things are looking up
Did you know that VLOOKUP actually looks down? That’s right, it finds the first entry from the top down. The default XLOOKUP also looks down, but can start from the bottom and look up.
Free Webinar Recording – Excel Budget Challenge Solution
Feedback score 92% based on 83 responses
In February 2020 I reviewed my solution to an Excel Budget Challenge from late 2018. This included some advanced Excel budget techniques.
The detailed pdf manual and example file can be downloaded using the button below. Content listed below the video.
CPD note – if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances.
This session includes a lot of useful content and it brings together a number of different techniques. The content is worthy of a paid session but since it was a public challenge I am presenting the session for free.
The materials includes the challenge documentation, the pdf manual and the solution file. I assume you have read the documentation. You also receive the blank Excel file if you want to create your own solution.
Techniques/topics covered include
- using INDEX-MATCH (better alternative to VLOOKUP)
- 3-D formulas to summarise all report sheets and techniques to make using them easy
- using a reporting template to speed up creation
- validations
- extracting sheet names
- automating reports
Excel XLOOKUP Flexibility
Part two
The INDEX and OFFSET functions can return a reference to a cell, something VLOOKUP can’t do. XLOOKUP can return a cell reference, let’s see one way to use it.
New XLOOKUP Function in Excel
Part One
It’s finally here, well it is if you have the monthly update cycle of the subscription version of Excel.