Mr Excel & excelisfun Trick 41: VBA or Formula Extract Prefix for VLOOKUP

[karol11099109]

Bill is a great solution to the formula!

In my life I would not come to that.

Large beer for this piece!

[ExcelIsFun]

EXCELlent!!!

[oceanic14123]

It is amazing to watch Mike explain his formula inside out. I wished I had a professor like him back in college. MrExcel's vba approach is elegant; however, I wished MrExcel could explain more on the logic of the vba code similar to how Mike explained his formula. I cant apply his code in similar situations because I dont fully understand the logic of it.

[ExcelIsFun]

I am glad that the explaination was helpful!

[cs202020]

Hi.

Thanks much for sharing your knowledge, this is amazing I really fond of your tutorials :-)

Could you please write me, how did you get the function speed? I tried stopping the video many times but i could not got the clue ;)

Thanks

[ExcelIsFun]

Search for and watch this video title:

Excel Formula Efficiency 2: Time Your Formulas For Speed

[cs202020]

Thanks much for the reply, I got it :-)

[ExcelIsFun]

EXCELlent!!!!

[harmeet1421]

awesome...................god bless u

[ExcelIsFun]

Thanks!

[tirathmistry]

But thanks so much for your kind effort that you still put your effort for making Great tutorial in youtube

please keep educate us ok your channal is suspended by youtube but don't stop your tuts on youtube. youput your tuts along with mike

Thanks both of genus who play alwsome role to educate people

God bless you :-)

[ExcelIsFun]

You are welcome!

[tirathmistry]

awesome tutorial

Thanks so much for posting it

Mr excel we miss you on your podcast

which are located in youtube

we miss your Awesome,Great, valueable channel also.

[hamy72]

5 stars for Mike for the way he explains this this Megaformula in such neat progressive manner!

[ExcelIsFun]

I have fun doing it!

[foleymnufc]

Amazing, unbelievably amazing!

[ExcelIsFun]

I am glad that you like it!

[foleymnufc]

@ExcelIsFun very clever how you worked your way outwards! I'm gutted about mrexcel, hopefully they will get in touch with him and let him know what he's done wrong!