G Guest May 16, 2005 #1 How do I link a number to a word? ie If I type "Pleat" in cell A1 it will show "105" in cell B1? Is this possible?
How do I link a number to a word? ie If I type "Pleat" in cell A1 it will show "105" in cell B1? Is this possible?
D Don Guillett May 16, 2005 #2 If it is really that simple then in cell b1 =if(a1="pleat",105,"") or if you have a lot of this take a look in HELP index for VLOOKUP
If it is really that simple then in cell b1 =if(a1="pleat",105,"") or if you have a lot of this take a look in HELP index for VLOOKUP
G Gord Dibben May 16, 2005 #3 Chet How many of these words to numbers do you have? Just one or two and you could use Tools>Autocorrect Options. You could use the VLOOKUP Function with a table. See Debra Dalgleish's site for info. http://www.contextures.on.ca/xlFunctions02.html While you're there check out using Data Validation drop-downs for entering values to lookup. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben Excel MVP
Chet How many of these words to numbers do you have? Just one or two and you could use Tools>Autocorrect Options. You could use the VLOOKUP Function with a table. See Debra Dalgleish's site for info. http://www.contextures.on.ca/xlFunctions02.html While you're there check out using Data Validation drop-downs for entering values to lookup. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben Excel MVP
