Tag Archives: vlookup

Dear Analyst #41: How to do a VLOOKUP to the “left” without INDEX/MATCH with TikTok data

Since TikTok is in the news right now about who is going to buy them, I thought using some fake-ish TikTok acquisition data would be relevant for this episode. A classic Excel/Google Sheets challenge: how to do a VLOOKUP to the “left” e.g. your lookup column is not the first column in your lookup table. […]

Dear Analyst Episode 17: Excel introduces new feature XLOOKUP

New Excel feature alert! Probably one of the biggest announcements in a long time from the Excel world: a new function to supplant VLOOKUP and HLOOKUP. What is it you ask? The XLOOKUP function. Summary of XLOOKUP benefits I discuss some of the benefits, implications for new and existing users of Excel, and also some […]

Join our community of 5,000+ Excel and data analysis enthusiasts!

  • Learn Excel techniques and shortcuts
  • Episode updates from the Dear Analyst podcast about Excel
  • Updates on online and offline data workshops

Enter your e-mail and hit the blue button!