This earned me a free lunch from him 🥪

Level up in Excel, VBA, + VLOOKUP & XLOOKUP in one hour!!! 💃🏼 You’re invited to a FREE live Excel Class with Miss Excel! 🤍 REGISTER now at the links below: • Session 1 - Wed, July 26 at 12pm ET: • Session 2 - Fri, July 28 at 3pm ET: In this power-packed 1 hour session, we will take a deep dive into lookup functions such as VLOOKUP & XLOOKUP + tips for automating with VBA Macros! • Attend Live for Extra Bonuses 🎁 • 24 Hour Replay Access for All Registrants • Return to work with a new skillset 💥   🗓️ Two date / time options (same content at each): • Wed, July 26 at 12pm ET/9am PT • Fri, July 28 at 3pm ET/12pm PT 🎬 If you can’t make it live, replays will be available for 24 hours - however extra presents for those who come live! ✨ Once registered, remember to save the date into your favorite calendar app! 🍹 Have your computer and favorite drink ready! (This will be fun I promise!!!) 👯 Tag a friend to invite them too! 💃 Limited spots available! Make sure you register early. Comment below to let me know you’re coming! Note: This description contains affiliate links, which means that at no additional cost to you, we may receive a small commission for each purchase that you make using our affiliate links. This helps support our channel and allows us to continue creating valuable content for viewers like you. #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorial #sheets

Very informative

Index-match-match…the GOAT formula

Best part of living, learning something new...

Tom Honks

@SaveMyVideo

Xlookup would be easier, IMO.

@SaveToNotion #Excel

@GetVideoBot

Why not a simple V-Lookup? 🙄

One of the big limitations with VLOOKUP is that it can only search from left to right. In this example, we want to search from right to left.

@readwise save

@SaveToNotion #tweet #excel

@sendvidbot

This looks a little clunky to set up. Can anyone explain why you wouldn’t just do a normal Find and search for their name. How does using a little menu help?

Find and search is a reasonable alternative in a small dataset like this. The purpose of this video was to illustrate the use of INDEX + MATCH.