|On my worksheet, each cell(A1 through A601 has a 3 char value (a1= abc, a2=bcd, a3 = cde). THe corresponding B cell has a numeric value (B1 = 10, B2= 11, B3 = 12). In C1 the user user will be entering one of the 600 letter combinations in A1:A601. I need D1 to find the cell that contains the 3 char and report back the number in the corresponding B cell. |
In C1 the user will enter "bcd", I need to have D1 display 11.
Can anyone help me out with a formula for this.