Auto correct in Excel??

[meherhakwani]

Dears all Aik pic upload kr rha hun, excel ki. Me ye chahta hun k aesa koi method hy k age hum aik cell me just aik number/name/code enter kr den, jesa k pic me mene Roll Number ko lia hy, agr me srf Roll number enter krun to kia aesa ho skta hy k excel khud se roll number k enter krtay hi Name, Father name etc ki fields ko fill kr de. Jesa k Word me aesa auto correct hota hy, jahan hum aik short code likh detay hen to word aus ko khud se complete word bna deta hy, i.e. schl type kren aur word ais ko School bna deta hy,, kia excel me b word ki trah ki auto correct ki option hy kia?

[syar]

Dears all Aik pic upload kr rha hun, excel ki. Me ye chahta hun k aesa koi method hy k age hum aik cell me just aik number/name/code enter kr den, jesa k pic me mene Roll Number ko lia hy, agr me srf Roll number enter krun to kia aesa ho skta hy k excel khud se roll number k enter krtay hi Name, Father name etc ki fields ko fill kr de. Jesa k Word me aesa auto correct hota hy, jahan hum aik short code likh detay hen to word aus ko khud se complete word bna deta hy, i.e. schl type kren aur word ais ko School bna deta hy,, kia excel me b word ki trah ki auto correct ki option hy kia?

1. Auto correct excel m bhe hota ha.
2. agar aap n kisi dosri sheet m pehle he sa roll number aur un ki tafseel bana rakhe ha jese name,class etc tu ya possible ha. is ko aap VLOOKUP k formula sa achieve kar sakte hain. is k leye agar aap file share kar lain tu bahtar ho ga. ya is forum p vlookup ka aik tutorial ha search kar lain. mere pas link nahee ha wrna m share kar deta.

regards

[meherhakwani]

ok thank u Syar bro

[*Xpert~Baba*]

ok thank u Syar bro