Forum Discussion
matching an extracted character to one in a table in excel
For a letter extracted from a string, I am trying to find out in which row of the column is that character located.
The process to find an entered letter in E3 works fine, but the match function will not take the character in E3 when is a result of another function.
Is it any way to do what I need to be done?
7 Replies
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.
