[VIDEO] How to carry out a VLOOKUP within Text in Excel

in excel •  6 years ago 



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

#powerquery


Paula Guilfoyle Youtube Channel


Posted from YouTube via Share2Steem

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!