wildcard

I want to us * in a drop down list to return all results of a query. This is not working for some reason. The data has "y", "n", and i want to use * to pull all results when I change the drop down selection. Any ideas why? Thanks, Trent

I would like to use a wildcard to check if a folder exist. i have tried the following: "C:\Users\*\Desktop\New folder" "C:\Users" & "*" & "\Desktop\New folder" "C:\Users\ + "*" + "\Desktop\New folder" i get, "bad file name or number." is there a way to do this? Sub TestForDir()Dim strDir As...

In Excel, the following VBA code does not work properly. dlgAnswer = Application.Dialogs(xlDialogOpen).Show("day*.xls") It opens the Dialog Box but shows all files in the folder (including day*.xls). I was expecting it to show only the files starting with filename as day* . I tried Fileopen...

I am performing an if formula that has 2 AND criteria, fo which one is a contains wildcard. I read that countifs may be the solution but I am still off the mark Can anyone help please? Many thanks

Hello, I am currently trying to clean up contact information at my firm. The goal is to search client names on sheet A [e.g. Waltham City of (MA)] for state abbreviations in parenthesis. If an abbreviation exists, match this to state abbreviations in parenthesis listed on sheet B and pull (via...

Hello, This is a part of the code that i have written, and what i wanted to do is to add a wildcard at the lookup value like in a common formula for instance : =VLOOKUP("*"&C1&"*";A1:B2;2). I need to apply the asterists at the beginning and at the end in the code. Range("E2").Select For i =...

I am setting up a spreadsheet to collect monthly figures. Of these figures I want excel to automatically calculate a percentage using two figures. I have this formula just fine. I want to have the formula present for all future months so that when I input the figures it automatically calculates...

Hey there, I know you cant really put a wildcard in a if statement but does anyone have any suggestions to get this formula to work? =IFERROR(INDEX(Number; MATCH(0; COUNTIF(F$14:$F14;Number)+IF(Priority<>$C$3; 1; 0)+IF(SelectedCustomer<>Customer; 1; 0); 0)); "") I want the selectedcustomer to...

Hi, I have an issue whereby I download data each month and the text in these cells changes slightly each time so it’s not possible to use a standard vlookup. What I would like to do is lookup specific text in one cell to return a value in another. For example the following is in these cells...

Hello - I've been searching the boards and the web. I can't seem to get the logic and put things together. I can't find the thread or a web page. Perhaps I'm searching the wrong terminology. I want to have partial/wildcard search capabilities. I know I'm making this more complicated than I...

I work in MS Access almost exclusively in Design View because I have to do quick little queries often and it is fast and easy. With that caveat, I would prefer to have a solution in Design View if at all possible. I am trying to combine wildcard queries that are both "Like" and "Not Like". When...

So, I have a list of employee names that I'm matching a plan type (there are multiple plans per employee) and having it return a value. My issue is that the value from the sheet that the information is on will sometimes have a space at the end of the employee name. I've been trying to use a...

I'm struggling to use a wildcard with an if statement. my formula is "=IF(OR(BZ1="99",BZ1="99"&"*"),"True","False")" I need it to check the cell and if it has either 99 or variations of 99- then be true.

Hi, Assuming these are 2 seperate lists in different tabs I would like to return the value in the second column as it is the closest match. Is this possible? If I wanted to return the first column i would use vlookup("*"&a1.... <tbody> Rehab Support Worker Support Worker Assistant...

I have an issue where my company got into the habit year's ago of denoting discontinued product with an astericks in our product description field. Management do not want this changed. This is an issue for me. Is there a way where I can use the astericks in a formula where only an astericks...

Hi, All... I am trying to write code that will open a spreadsheet so it can be used for a series of vlookup formulas, but the file name has a date in it that changes as updates are made. I am pretty sure the solution is just to use a wildcard for the date piece of the file name, but I've never...

Having a problem getting this sumifs formula to work correctly using a wild card. Sum Range: Col I Criteria Range 1: Col C Criteria 1: Starts with "10" (there is a 6 digit number - not a number stored as text, 1st 2 digits should be 1 and 0) Criteria Range 2: Col N Criteria 2: = C$1...

Is there away to “move” the info that’s captured with the * wildcard character when you’re using Find & Replace? For example: I’m looking at a sheet with the following in Column A 1 Public Records of Baltimore County, State of Maryland 2 Public Records of Cuyahoga County, State of...

I am trying to do a find replace on formulas that include * for multiplication. A lot of cells that have *12, *11, *10, etc. and I want to replace all of these to be *1. When I try to do a find replace of '*12' it replaces everything prior to the *12 since the * is flagged as the wildcard...

Hi forum, I'm new here and I've been having a problem to do a 2 step search. Let me (try to) explain: I've got 2 tables I need to compare Table A (30 records) name, Street, zip, town, Value 1 Table B (50000 records) name, Street, zip, town Step 1 - Compare the following to narrow it down...