I didn't start from the beginning which I should have. I almost understood this, you have a very pleasant speaking voice and make it easier than many tutorials I have seen
Wow, thank you for that compliment)))) Sometimes I can be slow (detail-oriented i say haha) but if you are having an issue getting it working, feel free to ask in the forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment If you ask specific questions here, there is a chance that I won't notice it just because I get a lot of comments and replies to my comments don't seem to pop-up again in my comment notification thing on here. Have a good weekend!)
@@TeachExcel I agree. You don't come across as a know it all, very pleasant to listen to, you enjoy demonstrating the many neat tricks and functions excel has to over, easy to follow, great examples.
Thanks! I love em, its like a taste of programming almost haha. Also, I accidentally removed your comment on the PI video last week while removing some spam that was above your comment, sorry about that!
I knew wildcards were powerful but struggled using them, by not understanding the rules obviously. Great explanation but leaves me with more questions (situations to practice!) like combining wildcards: xxxx?* at least one character after and *?xxxx at least one character before. Also how use tilda when using cell references inplace of hard coding a text string. Always more to learn. Thanks again.
You're very welcome! And maybe here's another thing to protect from your co-workers, lest they decide to remove that pesky and 'useless' multiplication sign in the lookup formula hahah
A few different ways to do this: www.teachexcel.com/excel-tutorial/1933/vlookup-to-return-all-matching-results www.teachexcel.com/free-excel-macros/201_vlookup-macro-to-return-all-matching-results-from-a-sheet-in-excel.html www.teachexcel.com/free-excel-macros/206_excel-macro-that-searches-entire-workbook-and-returns-all-matches.html www.teachexcel.com/free-excel-macros/205_vlookup-macro-to-return-all-matching-results-and-stack-them-with-previous-results.html www.teachexcel.com/search.php?section=1&q=return+all+matches&forum=yes&s1=yes&s2=yes Last link is the search result page where I found these :) Hope this helps!
I am working on trying to figure a Vlookup to pull info from multiple different sheets/tabs in one document. Essentially I have a sheet that is showing which parts are needing to be ordered. some tabs have parts in them that begin with the letter P to signify they are purchased parts. is there a way to look up the part number and quantity from all sheets in the document, and display the part # and quantity on the "Order Parts" tab/sheet?
Excellent video, thank you!! I'm trying to do a partial vlookup across data array that sometimes has an asterisk. Example, I'm trying to match up 'ABC Moving' in sheet A with 'ABC*Moving' in sheet B. If I'm doing the vlookup from sheet B to A, it finds the match; however, if I'm doing it from A to B, it won't find the match.
Wonderful! I liked this wild cards character mention..however I would appreciate of u could explain use of Index Match more in this reference as VLOOKUP only search data right of the look up value ijn source sheet.Please explain keeping in mind the absolute ref as well. It confuses me alot.
I have a few Index/Match tutorials on here and on TeachExcel.com but I will make a note to try and include a new video on it when I can - if I forget, feel free to message me again!
Thank you! How can I do to find for example: "Sonic Temple" in a list where it could appear as "Sonic Temple Event" . And what if we want to see it like word by word. Example I want to search any of those 3 words: Sonic Temple Festival in a list where it could be written: Temple Festival, Or Temple Event or Sonic Bloom. How can I get a return on all of these words? :) thanks
Hello, I need your tip for this unusual scenario. I am looking up a value from one sheet in another sheet. Source value is CF19724071291022144694151. Target sheet contains the lookup value in the middle of a cell starting preceded by an * , the match should return a value. How do i construct the formula. My formula is not returning value all the time. Not sure why. Thanks for your time and attention
Need to match a partial inside ( ) Example need to find L1 inside parentheses (L1) so I can match L1 to a table. Could be 2 or 3 characters inside the () (L1) or (L10) Help! :)
Hi Cathy, go ahead and ask this in our forum on teachexcel.com and upload a sample file with some data and it will be much easier to help. And include your version of excel, becaue there are great new functions that you might be able to use if you have excel 365.
Depends what you mean exactly, ask in our forum and provide more information and it will be easier to help: www.teachexcel.com/talk/microsoft-office?src=yt_comment
Hi there, you can ask your Excel questions in the forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment There you can upload sample files and code and its easier to help)
I didn't start from the beginning which I should have. I almost understood this, you have a very pleasant speaking voice and make it easier than many tutorials I have seen
Wow, thank you for that compliment)))) Sometimes I can be slow (detail-oriented i say haha) but if you are having an issue getting it working, feel free to ask in the forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment
If you ask specific questions here, there is a chance that I won't notice it just because I get a lot of comments and replies to my comments don't seem to pop-up again in my comment notification thing on here.
Have a good weekend!)
@@TeachExcel I agree. You don't come across as a know it all, very pleasant to listen to, you enjoy demonstrating the many neat tricks and functions excel has to over, easy to follow, great examples.
I had watched several tutorials on this task. Some abit complex. But this one is so simple and gives instant results.
I'm glad to hear it :)
Videos seems to be discussed an ordinary matter but watching videos discloses that the matter is "extraordinary". 👍
Excellent explanation about the use of wildcards in the function VLOOKUP in Excel. Thank you!!!
You're very welcome! I'm glad you liked it! These little guys are so easy to forget but can be so helpful)
Thank you so much. I have been searching so long days a solution for these types of problems. You make it clear and easy. Thank you so much
This was super helpful, been looking so long for a clear guide on how to understand this lookup. :-)
Great.. these are fun.. can do lots of creative things with wildcards. Thanks for the video! Thumbs up!!
Thanks! I love em, its like a taste of programming almost haha. Also, I accidentally removed your comment on the PI video last week while removing some spam that was above your comment, sorry about that!
I knew wildcards were powerful but struggled using them, by not understanding the rules obviously. Great explanation but leaves me with more questions (situations to practice!) like combining wildcards: xxxx?* at least one character after and *?xxxx at least one character before. Also how use tilda when using cell references inplace of hard coding a text string.
Always more to learn. Thanks again.
Great Stuff..Really Nice Tutorial Using Wild Card Characters.Thank You Sir :)
You're very welcome! And maybe here's another thing to protect from your co-workers, lest they decide to remove that pesky and 'useless' multiplication sign in the lookup formula hahah
Great information. These formulas work to return the first value in a list. But, what could you use to find all values that meet the lookup criteria?
A few different ways to do this:
www.teachexcel.com/excel-tutorial/1933/vlookup-to-return-all-matching-results
www.teachexcel.com/free-excel-macros/201_vlookup-macro-to-return-all-matching-results-from-a-sheet-in-excel.html
www.teachexcel.com/free-excel-macros/206_excel-macro-that-searches-entire-workbook-and-returns-all-matches.html
www.teachexcel.com/free-excel-macros/205_vlookup-macro-to-return-all-matching-results-and-stack-them-with-previous-results.html
www.teachexcel.com/search.php?section=1&q=return+all+matches&forum=yes&s1=yes&s2=yes
Last link is the search result page where I found these :)
Hope this helps!
Amazing video !!!!!!!!
Do I have to add a column with the numbers? Example. In your example you have column E
I am working on trying to figure a Vlookup to pull info from multiple different sheets/tabs in one document. Essentially I have a sheet that is showing which parts are needing to be ordered. some tabs have parts in them that begin with the letter P to signify they are purchased parts. is there a way to look up the part number and quantity from all sheets in the document, and display the part # and quantity on the "Order Parts" tab/sheet?
This is very helpful.
Excellent video, thank you!! I'm trying to do a partial vlookup across data array that sometimes has an asterisk. Example, I'm trying to match up 'ABC Moving' in sheet A with 'ABC*Moving' in sheet B. If I'm doing the vlookup from sheet B to A, it finds the match; however, if I'm doing it from A to B, it won't find the match.
Wonderful! I liked this wild cards character mention..however I would appreciate of u could explain use of Index Match more in this reference as VLOOKUP only search data right of the look up value ijn source sheet.Please explain keeping in mind the absolute ref as well. It confuses me alot.
I have a few Index/Match tutorials on here and on TeachExcel.com but I will make a note to try and include a new video on it when I can - if I forget, feel free to message me again!
@@TeachExcel sure ..I appreciate your quick response which is often unusual with others UA-camrs.
You're very welcome my friend!)
Very useful , thanks very much
Very informative.
Glad to help)
Thank you! How can I do to find for example: "Sonic Temple" in a list where it could appear as "Sonic Temple Event" . And what if we want to see it like word by word. Example I want to search any of those 3 words: Sonic Temple Festival in a list where it could be written: Temple Festival, Or Temple Event or Sonic Bloom. How can I get a return on all of these words? :) thanks
Hello, I need your tip for this unusual scenario. I am looking up a value from one sheet in another sheet. Source value is CF19724071291022144694151. Target sheet contains the lookup value in the middle of a cell starting preceded by an * , the match should return a value. How do i construct the formula. My formula is not returning value all the time. Not sure why. Thanks for your time and attention
Please can you show us how to get data using vlock up if the main reference duplicate in same colume ,, yours truly
Wonderful
Thanks Ashok! I'm really glad you like it :))
Nice wild card formula. Can it work also in numbers sir? Thanks
Hi Alvin, it depends on your setup, but I feel like it should work well. Give it a try!
Thank you so much
God bless you with fmly
Thank you! You too, and stay safe!)
Need to match a partial inside ( ) Example need to find L1 inside parentheses (L1) so I can match L1 to a table. Could be 2 or 3 characters inside the () (L1) or (L10) Help! :)
Hi Cathy, go ahead and ask this in our forum on teachexcel.com and upload a sample file with some data and it will be much easier to help. And include your version of excel, becaue there are great new functions that you might be able to use if you have excel 365.
This is not working for me . Can you please help me. In B column there is a "rite aid" and in other column it is" rite aid corporation"
Sir how can use this formula to many partial text condition
Depends what you mean exactly, ask in our forum and provide more information and it will be easier to help: www.teachexcel.com/talk/microsoft-office?src=yt_comment
excellent
I got a #N/A error, any idea please?
مرسی
Do you have account at Facebook , how can I reach to you master
Hi there, you can ask your Excel questions in the forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment
There you can upload sample files and code and its easier to help)
TeachExcel
Tremendous respect 🌹🌹