http://theexcelclub.com/how-to-carry-out-a-vlookup-within-text-in-excel/
Download the data to practice this skill from the blog post above.
we wish to prepare a lookup that will use the part of the text from a stock code to lookup and return the area where the stock item can be found in the warehouse
In this tutorial you will learn how to combine vlookup with text functions. More details and other examples are shown on the blog post
The Excel Club Blog has been powered with #STEEM. That means we are a tokenized website and you can earn while you learn Excel, PowerBI and DAX. All you have to do is engage with the post on The Excel Club Blog, so if you have any questions or comments I would encourage you to post them on the blog and not here on the video
Sign up to our newsletter
http://theexcelclub.com/newsletter/
Watch more Power BI videos
https://www.youtube.com/playlist?list=PLJ35EHVzCuiEsQ-68y0tdnaU9hCqjJ5Dh
Watch more Excel Videos
https://www.youtube.com/playlist?list=PLJ35EHVzCuiFFpjWeK7CE3AEXy_IRZp4y
#share2steem #excel #json #steem #exceltips #tutorial