Jul 27 2021 08:30 AM
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?
Jul 27 2021 08:47 AM
@rcrichfl Perhaps like so?
Jul 28 2021 12:32 PM
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.
Jul 28 2021 09:29 PM
@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.
Jul 30 2021 11:00 AM
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,
Jul 30 2021 09:46 PM
@rcrichfl That doesn't matter. Seems to work on my end.
Aug 01 2021 03:05 AM
Thank you, Riny for your help. However, in the file you sent, cell E3 does not contain the LEFT(E2,1) command. Can you verify, please? I am using the same MATCH expression you show in E5. The only difference is that for the table I am using the range instead of a name. Anyways, I assigned a name to the table, and still, I get #N/A.
Aug 01 2021 03:43 AM