INDEX(MATCH) in #excel

preview_player
Показать описание
If you have Microsoft 365, you may want to use XLOOKUP instead. #excel #spreadsheets #workhelp
Рекомендации по теме
Комментарии
Автор

I don’t really leave comments, but this video has been extremely helpful. I use this function a lot at work and can always refer to this video when I need a quick review. Thank you

jug
Автор

Two nice features about INDEX(MATCH()) is it can do "left lookups", and can also easily be made into a two-way lookup by adding another MATCH() for the column number, making it an INDEX(MATCH(), MATCH())

gorflunk
Автор

A powerful index-match function made beautiful 💯

juniorethoko
Автор

Great job being succinct! High quality educational content without the fluff 10/10

TheRedsharks
Автор

OMG ur this vd help me alot in my test, u don't know how much happy I'm rn.😁♥️

kanchanrawat
Автор

This is great! What if there's no match, is there an else funtion to return blank im getting n/a on no match 🙏

xosxos
Автор

The number 8342 written 2 times need clarification

atherather