Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by StrekVoyager
-
How to vlookup with wild card and return multiple values
Okay so this will allow for 6 variations if i subtract 1 each time. What if I want to return 30 items?- StrekVoyager
- Post #6
- Forum: Microsoft: Office
-
How to vlookup with wild card and return multiple values
=LEFT(A2,FIND(" ",A2)-1) Okay can you explain what this is doing? Because A2 is now B2 when i insert to the left of A.- StrekVoyager
- Post #5
- Forum: Microsoft: Office
-
How to vlookup with wild card and return multiple values
Item to Lookup [Cert] (A2) (LOOKUP AREA) Name Loc Notes [Cert] =VLOOKUP("*"&$A$2&"*",$A$26:$A$39,1,FALSE) (LOOKUP ARRAY A26:A39) Name Loc Notes [Certa] 1304 1533 Complete [Certa] 1304 1534 ERROR [Certa] 1100 1535 Complete [Cert] 2215 1536 Complete [Prod] 102 1537 Complete [K21119] 10009...- StrekVoyager
- Post #3
- Forum: Microsoft: Office
-
How to vlookup with wild card and return multiple values
Okay I have a problem with a vlookup using a wild card. In my example i want to lookup anything like [cert] under the names column. But I also need to see both multiple instances of the same name as well as the other names contain anything like cert. So right now I am using...- StrekVoyager
- Thread
- Replies: 7
- Forum: Microsoft: Office
