Excel: VLOOKUP - How to Find the Next Largest Value
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: https://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 https://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 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Mike Thomas 26 Май 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,27 раз и оно понравилось 2 людям.