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

See Mr Excel and excelisfun do VBA and an array formula to extract a varying length number prefix and then use that as the lookup_value for VLOOKUP. See the functions: LEN, INDIRECT, ROW, MID, ISERROR, MATCH, LEFT and VLOOKUP.

Category:

Science & Technology

Tags:

• Excel
• VBA
• or
• Formula
• VLOOKUP
• Extract
• Varying
• Length
• Prefix
• for
• lookup_value
• excelisfun
• Bill
• Mr
• Jelen
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• LEN
• INDIRECT
• ROW
• MID
• ISERROR
• MATCH
• LEFT
• function

[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!

[ExcelIsFun]

EXCELlent!!!!

[cs202020]

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

[ExcelIsFun]

Search for and watch this video title:

Excel Formula Efficiency 2: Time Your Formulas For Speed

[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]

Thanks!

[harmeet1421]

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