partial

Hi Folks, I require some assistance looking up a partial string using the match function. I know how to use wildcards as follows: =MATCH("*"&E1&"*",$A$1:$A$1000,0) This looks for any part of E1 in range A1 to A1000 if E1 was "dav" and A1 was "dave" then it would return 1 But it falls over...

hello, I Was wondering if there is a way to set an Excel Cell Background Color Partially. thankx for you're time.

Hi, So I'm encountering a weird issue so I'm wondering if someone can shed some light on it for me. In a workbook, I can write a formula to reference a cell in a closed workbook like this: ='E:\Desktop\[Performance.xlsx]Data'!$B$158 The thing that is weird is that it only works some of...

Hello, Used the forums plenty of times and always found my answer but first time where I couldn’t find a solution to my problem. In essence, I believe I’m trying to do a VLookup with a partial text match. I tried vlookups with wildcards, indexes with matches, and none of them are working. Column...

If starting on a cell such as D7, how do I reference a PARTIAL folder path listed in cell F7? The path will vary in how many subfolders it has. I simply want to reference the path MINUS the last subfolder. (e.g. \\foldler1\folder2\FolderIDon'tWantToReference, but remember the names of the...

Hello, I have Excel 2003. I'm trying to find a formula that will calculate results across multiple worksheets based on criteria such as (part) of the name of worksheets, and will continue to work without me touching it as I add more sheets to the workbook (will recalculate new sheets...