If you've perform lookup before it's usually looking up something with one criteria (i.e., finding the sales for SKU 123). But what if you had multiple criteria to lookup like sales for SKU 123 that are blue and size is small? Wow that's a lot of criteria to put into a lookup function. But it's actually not that hard to do a lookup with two or more values. In this video I'll show two examples of how you can accomplish this task. One example uses VLOOKUP and the other uses INDEX / MATCH. This can be considered a two way lookup, but your can also use this method for a three way ( or more) lookup to do a multiple match (when there a values to lookup in multiple cells or multiple columns).
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain....
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~
Негізгі бет Perform a Lookup with Multiple Criteria
Пікірлер: 130