Phonetic Alphabet Code Generator

[ujaiswal]

Dear experts,

I have data as A, B, C.... column A range(A2:A27) & in column B alfa, bravo, charlie..(B2,B27)

I want if i write in column D (D2) as word Umesh it will reflect me as Uniform, Mike, Echo, Sierra, Hotel in (E2)

Do help me out if you find any formula or any solution related to this

This will b really an honor if you would do this

Thanks in Advance
Umesh jaiswal

[Ron Coderre]

With
D2: a word....Umesh

And this list:

	A	B
2	A	Alpha
3	B	Bravo
4	C	Charlie
5	D	Delta
6	E	Echo
7	F	Foxtrot
8	G	Golf
9	H	Hotel
10	I	India
11	J	Juliet
12	K	Kilo
13	L	Lima
14	M	Mike
15	N	November
16	O	October
17	P	Papa
18	Q	Quebec
19	R	Romeo
20	S	Sierra
21	T	Tango
22	U	Uniform
23	V	Victor
24	W	Whiskey
25	X	X-Ray
26	Y	Yankee
27	Z	Zulu

This formula returns the phonetic word for the first letter of the referenced word:

E2: =LOOKUP(D2,$A$2:$A$27,$B$2:$B$27)

In that example, the formula returns: Uniform

Is that something you can work with?

[ujaiswal]

It seem very close enough which i am looking for

it show only uniform against Umesh

I want for umesh to show (pronounce on telephonic conversation to the customer) as (Uniform, Mike, Echo, Sierra, Hotel)

Hope you me out in this too

Thanks for your contribution