![]() To see the results of the array formula, click in the formula bar, and press the F9 key. There are wildcard characters before and after the cell references to D1:D3, so the text will be found anywhere within the text string. This formula needs to be array-entered, so press Ctrl + Shift + Enter. We can use the wildcard with COUNTIF, to see if the string is found somewhere in the text. When you want to find text that’s buried somewhere in a string, the * wildcard character is useful. ![]() Would you use INDEX and MATCH to find the code, or another method? Keep reading to see my solution, and please share your ideas, if you have other ways to solve this. Each text string contained one of the codes, and Jodie wanted that code to appear in column B. ![]() Jodie sent me a picture of her worksheet, with text strings in column A and codes in column D. Last week, Jodie asked if I could help with a problem, and INDEX and MATCH came to the rescue again. See how to find text with INDEX and MATCH. Is there a harder working team in Excel, than the reliable duo of INDEX and MATCH? These functions work beautifully together, with MATCH identifying the location of an item, and INDEX pulling the results out from the murky depths of data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |