Forum Discussion
matching an extracted character to one in a table in excel
rcrichfl Perhaps like so?
Almost. I apologize I missed adding one parameter. The match must be able to distinguish upper case from lower case. Here is the new table.
I tried your Mach suggestion and works as expected, but I cannot make it to discriminate by case type.
rcrichflIOk, the you need to revert back to your original formula that uses EXACT, but change it a bit. The EXACT function takes the search value first, then the search array. You tried it the other way around. And easier if you use a named range for the entire list of characters (starting from A1), including the header. I called it myList in the attached workbook. Now it will find 8 as the row number. If you leave out the header it will find 7, being the 7th element in the array, starting in A2, And you will need to add 1 to return the row number.
Thank you for your effort. However, the formula you used works if the letter to look for is entered as a text in the cell, which is not what I am looking for. If you go back to my file, you will find that in that cell there is a function that extracts the character from a string in another cell.
Therefore my original request is still open.
Kindly,
