Does it works on returning multiple values based on a cell value. Lets say we have companies and would like to see the list ( records) of all employees of a selected company with names, titles, email addresses etc.? Also is it possible that these records can be edited/updated right after showing up/ filtering?
Wonderful Mate ! Though it would take getting used to. Can I make a Suggestion? Do include a test (slightly higher on difficulty level) on the same worksheet so that we can test our knowledge and get further practice on it.
What do you think... is this Function better than VLOOKUP and INDEX + MATCH? Comment below.
no it's not, it cannot work when you have multiple rows. Still cool but not very useful.
@@lordtyranus08 yes...it cannot work with multiple rows. So, still match index is best option.
No.. Its useful only lookup one value... It can use when wants to multiple criteria...
Index and match are best...
Thank you
Does it works on returning multiple values based on a cell value. Lets say we have companies and would like to see the list ( records) of all employees of a selected company with names, titles, email addresses etc.? Also is it possible that these records can be edited/updated right after showing up/ filtering?
Wonderful Mate ! Though it would take getting used to. Can I make a Suggestion? Do include a test (slightly higher on difficulty level) on the same worksheet so that we can test our knowledge and get further practice on it.
Thanks for your comment. That is a really good suggestion so will look to update/ and include this going forwards! 😄
Would I work the same way if we used index match match instead?
I liked it much brother
this function is good
so, on my desktop none results, just "#value!"
why ?
thanks a lot
I want spellnumber in vba function
I think this could do what you would normally do with index match? More simple as well IMO.
plzzzzzzzzzzzzzzzzzzzzzzzz brother send the peoject file . It is helpful
Hello. Link to the project file is located in the description below the video.