Is there a way to have a monetary vaue appear when a letter is typed into a cell?
L Linds Dec 21, 2005 #1 Is there a way to have a monetary vaue appear when a letter is typed into a cell?
N Niek Otten Dec 21, 2005 #2 Tools>Autocorrect options If this is not at all what you mean, try being a bit more specific
D Dave Peterson Dec 21, 2005 #3 Maybe you could use a table on another worksheet and a helper cell that would contain an =vlookup() formula. =if(a1="","",vlookup(a1,sheet2!a:b,2,false)) You may want to read Debra Dalgleish's notes: http://www.contextures.com/xlFunctions02.html
Maybe you could use a table on another worksheet and a helper cell that would contain an =vlookup() formula. =if(a1="","",vlookup(a1,sheet2!a:b,2,false)) You may want to read Debra Dalgleish's notes: http://www.contextures.com/xlFunctions02.html
G Gord Dibben Dec 21, 2005 #4 Linds In the same cell? You would need to use Autocorrect or event code. In another cell use this =LOOKUP(A1,{"A","B","C","D","E"},{10,30,40,50,60}) Gord Dibben Excel MVP
Linds In the same cell? You would need to use Autocorrect or event code. In another cell use this =LOOKUP(A1,{"A","B","C","D","E"},{10,30,40,50,60}) Gord Dibben Excel MVP
