In this step-by-step tutorial I show you how to use Excel's INDEX and MATCH functions to perform non-exact lookups and find the next largest value in an Excel list. Unlike VLOOKUP, which can only return the largest value that is less than the lookup value, INDEX and MATCH offer a powerful workaround for users who don't have XLOOKUP.
For full details see the timestamps below:
🗒 Notes and Resources
Download a copy of the file used in this video: app.box.com/s/xol5biuck7mm29b...
The formulas that I used in the demos:
=VLOOKUP(B2,D2:E27,2,TRUE)
=VLOOKUP(C3,F3:G7,2,TRUE)
=INDEX(F3:G7,3,2)
=INDEX(F3:G7,MATCH(C3,F3:F7,1),2)
=INDEX(F3:G7,MATCH(C3,F3:F7,1)+1,2)
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #vlookup #indexmatch
Негізгі бет Excel: VLOOKUP - How to Find the Next Largest Value
Пікірлер: 4