Is there a way to have a monetary vaue appear when a letter is typed into a
cell?

ToolsAutocorrect options

If this is not at all what you mean, try being a bit more specific

--
Kind regards,

Niek Otten

"Linds" wrote in message
...
Is there a way to have a monetary vaue appear when a letter is typed into
a
cell?

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

Linds wrote:

Is there a way to have a monetary vaue appear when a letter is typed into a
cell?

--

Dave Peterson

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

On Wed, 21 Dec 2005 09:16:02 -0800, "Linds"
wrote:

Is there a way to have a monetary vaue appear when a letter is typed into a
cell?