Coding letters and numbers

[Linds]

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

[Niek Otten]

Tools>Autocorrect options

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

--
Kind regards,

Niek Otten

"Linds" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to have a monetary vaue appear when a letter is typed into
> a
> cell?

[Dave Peterson]

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

[Gord Dibben]

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" <[email protected]>
wrote:

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