View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Little help please...

"After his second post, I was assuming the phonetic alphabet":

http://en.wikipedia.org/wiki/NATO_phonetic_alphabet

--
Regards,
Tom Ogilvy


"NickHK" wrote:

Tom,
Your crystal ball is working wonders today, assumning you are correct.
From the OPs description, I was at a complete loss.

NickHK

"Tom Ogilvy" ...
In B1
=if(isnumeric(A1),A1,Vlookup(A1,Table,2,false)

Before doing this, on another sheet put
ColumnA ColumnB
A Alpha
B Bravo
C Charlie
D Delta
E Echo
F Foxtrot

and so forth.

Select those cells and name them Table (insert=Name=Define)

--
Regards,
Tom Ogilvy

"Fraelorn" wrote:

I am somewhat of a newbie when it comes to coding Excel. Where abouts
would I
go to make use of this information, or could you possibly provide an
example
of how to configure one set of cells for this?

ie. (information to be entered where 'C' is, Charlie should be the
output)

[ A ] [ B ]
| C | Charlie |

Don't mean to take a bunch of your time for this, but would appreciate a
little more guidance. Thanks guys.


"Jim Thomlinson" wrote:

Are you looking for the Code worksheet function
=Code(65) returns "A"
--
HTH...

Jim Thomlinson


"Fraelorn" wrote:

What I'm trying to do, which I hope I can.. is create an Excel form
in which
I can enter a set of characters, Letters/Numbers only, in one column
(one
character per field) and in the opposing column, display either
Numeral X, or
the Alphanumeric for the character entered.

Can anyone give me some suggestions?