Hello
it would be nice to add the INDEX function and INDEX/MATCH combination to this topic.
Also using VLOOKUP to do a left lookup is interesting.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Lookup and search functions
Replies
Thanks for the input! INDEX and MATCH are definitely on the To-Do list!