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())
Great job being succinct! High quality educational content without the fluff 10/10
OMG ur this vd help me alot in my test, u don't know how much happy I'm rn.πβ₯οΈ
A powerful index-match function made beautiful π―
Thanks man you are a life saver
Thanks!!! You're save me π₯Ή
NINE NINE!!!
Thank you, this was very helpful.
bro left Scully and Hitchcock ππ
Great
Thank you so much.
This is great! What if there's no match, is there an else funtion to return blank im getting n/a on no match π
Brooklyn nine nine names lol
Brooklyn 99 names?ππ
I tried but got spill π
The number 8342 written 2 times need clarification
Why doesn't it work when I use the VLOOKUP formula?
Brooklyn 99
doesnt work
@jug525