How to do a VLOOKUP with multiple conditions or criteria (3 methods) Excel/Google Sheets - Tutorial скачать в хорошем качестве

How to do a VLOOKUP with multiple conditions or criteria (3 methods) Excel/Google Sheets - Tutorial

There are times you need to do a VLOOKUP and have multiple criteria or conditions for your lookup value. The VLOOKUP function--by default--only let's you look up one value in your list of data. This means you can only look for one column of data. In this episode, I'll show you 3 different methods for doing a VLOOKUP when you have multiple columns you want to match on. Intro - 0:00 Basic VLOOKUP formula - 0:25 Method 1: ARRAYFORMULA with brackets (arrays) - 2:56 Method 2: INDEX/MATCH with INDEX - 9:38 Method 3 (Preferred): Combine multiple columns - 15:04 Advanced Excel formula class on Skillshare (see link below) - 18:34 👉 Advanced Excel class: Formulas & Features to Create Efficient Team Workflows: https://skl.sh/3S2XEyQ 👉 Subscribe to Dear Analyst: https://podcasts.apple.com/us/podcast... 👉 TikTok:   / dear.analyst   👉 Instagram:   / dear.analyst   👉 Original blog post for this podcast episode: https://www.thekeycuts.com/how-to-do-...