Articles

Excell One cell equal to another

October 4, 2005 at 05:47:57
Specs: xp

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.
Example:
In C1 the user will enter "bcd", I need to have D1 display 11.
Can anyone help me out with a formula for this.
Thanks


See More: Excell One cell equal to another

Report •


#1
October 4, 2005 at 07:24:35

Use vlookup.

Report •
Related Solutions


Ask Question