How to do in excel [Closed]

 Trowa -

if i write some thing in column A then column B automated generate the code (that i define) for that person.
just i need the name of person in column A and in column B match the name and generate code itself.

A1 B1
akram 4500
munir 4600
maqbool 4700
zafar iqbal 4800
habib 4900

thanks in advance.

1 reply

I don't understand, please rewrite your query.

You've entered a name and a code and now you want the code to be generated by itself ???

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!