Get the Download Files
Click here to download the files used in this webinar
What Happened?
Last week, I recorded a webinar for BhamQuants. Unfortunately, the video did not come through well on the webinar. So I rerecorded it on my own.
Unfortunately, I didn’t really have time to edit it this week. So you get to watch it raw and uncut, mistakes and all.
I hope you enjoy!
Questions?
Feel free to ask them down below in the comments section.
- All Excel LOOKUPs Explained - May 26, 2020
- How to: Power Query File From Folder - April 21, 2020
- Oz’s Excel Tip: Keep a Workbook for Random Data in Excel - January 23, 2020
Hi Jordan, I really liked the way the VLOOKUP with the array for the column numbers. Is there a way to make the array dynamic? I tried several solutions, for example using match to get the column numbers and creating then the array, but nothing was working…
Not that I know of. The alternative would be to use an index/match function, which I think you could actually get to work but I’ve not tried it.