Trying to do something similar to your "Partial Match vlookup" tab. My scenario has short one or two word lookup in A2:B10 Cells D3 down to ~D1000 have longer phases like: "I would love to live in Liverpool, UK" or "I just came from Hamburg, Germany and had a blast". Return in cell E3 down to ~E1000, 24 for Liverpool, UK and 12 for Hamburg, Germany and so on... Basically trying to use A2:B10 as a lookup, displaying column B in column E where column A exists in column D. Been searching or days, and your example is the closes so far to what I'm trying to accomplish. Thanks in advance.
Thanks Abdelrahman, yes I ignored the tilde ~ for these examples as I do not find it as beneficial as the ? and the *. It is in very rare instances that the Tilde is used. It means to treat a wildcard such as the * as a character and not a wildcard.
Great tutorial but how do you use a wildcard character in an =if(or statement? For example when you are referencing an empty cell or a cell with a specific character in it?
Thank you, Frank. I have a video on using IF for specific characters here - ruclips.net/video/0_IGpT0bYZY/видео.html Need to use the FIND or SEARCH functions instead of wildcards.
I don't believe you can use wildcards with the SUMPRODUCT function Jayjay. You could replace the (TB!A:A="IS-1*") part of the formula with (--ISNUMBER(FIND("IS-1",TB!A:A)) or with --(LEFT(TB!A:A,4)="IS-1")
Very well explained and very informative. Thanks Man
Thank you. Much appreciated.
Great tip. Been using VLookup for years and never knew!
Thanks Joe
Awesome & unique examples of wildcard characters, I have never seen before use to "*" in vookup value. Thanks you so much.
Your welcome Sanjay, thank you.
Another lesson learned! Thanks, Alan!
Awesome. Thanks Sandy.
Awesome ! Very Well explained !! Thank you very much Alan!!! 😃
My pleasure! Thank you Patricia.
Wonderful explanation
Thank you.
Great man! Super clearly explained!
Thank you, J G.
Utterly brilliant, you have a gift mate . I seriously recommend you to pursue a career in teaching if you aren’t already one
Thank you, Antonio. Much appreciated.
Could you please do a video on the If functions and the multiple application of it
Trying to do something similar to your "Partial Match vlookup" tab.
My scenario has short one or two word lookup in A2:B10 Cells D3 down to ~D1000 have longer phases like: "I would love to live in Liverpool, UK" or "I just came from Hamburg, Germany and had a blast". Return in cell E3 down to ~E1000, 24 for Liverpool, UK and 12 for Hamburg, Germany and so on... Basically trying to use A2:B10 as a lookup, displaying column B in column E where column A exists in column D.
Been searching or days, and your example is the closes so far to what I'm trying to accomplish.
Thanks in advance.
thanks lad
can you please guide? How can I use vlookup in opposite situation
Thank you so much Alan.
I need a vba code which can loop through all your videos and writes a nice comment beneath every one of them. 🌟 🌟 🌟 🌟 🌟
ha ha awesome Salim.
Great example of wildcard character, thank you
What about ~?
Thanks Abdelrahman, yes I ignored the tilde ~ for these examples as I do not find it as beneficial as the ? and the *. It is in very rare instances that the Tilde is used. It means to treat a wildcard such as the * as a character and not a wildcard.
Thank you
Your welcome Abdelrahman.
very good tutorial
Thank you Sami.
Great tutorial but how do you use a wildcard character in an =if(or statement?
For example when you are referencing an empty cell or a cell with a specific character in it?
Thank you, Frank. I have a video on using IF for specific characters here - ruclips.net/video/0_IGpT0bYZY/видео.html
Need to use the FIND or SEARCH functions instead of wildcards.
your explanation is very clear. It would be great if you help me in blow query
Thank you. The video does include an example with VLOOKUP.
nice video
Thank you Rahul.
The video is okay. Just that the text in the video are blurry. can't really see the formula you are inputting
Thank you. The blurry sounds like a streaming issue.
graet video
Thank you Hazem.
why doesnt this work? =SUMPRODUCT((TB!A:A="IS-1*")*(TB!N41))
sorry i meant this does not work =SUMPRODUCT((TB!A:A="IS-1*")*(Months
I don't believe you can use wildcards with the SUMPRODUCT function Jayjay.
You could replace the (TB!A:A="IS-1*") part of the formula with (--ISNUMBER(FIND("IS-1",TB!A:A)) or with --(LEFT(TB!A:A,4)="IS-1")
Computergaga OK thanks