The Column Function in Excel to make VLOOKUP more Dynamic
#Excel #vlookup #column
In a previous video, we looked at the use of VLOOKUP and we saw there were some limitations. In this video, you will learn how to use the COLUMN function to overcome one of the limitations of VLOOKUP. If you are using Excel 365, you can overcome many of the VLOOKUP problems with XLOOKUP but many people are not using Excel 365 and need this Excel old school trick.
By combining VLOOKUP with the COLUMN function you can make VLOOKUP more dynamic
watch the previous video on VLOOKUP
• VLOOKUP Basics In Excel
Learn about XLookup
• How to use XLOOKUP in Excel
Sign up to our newsletter
https://theexcelclub.newzenler.com/f/...
Watch more Power BI videos
• Power BI
Watch more Excel Videos
• Learn Excel - Playlist