Excel problem pls help me urgently

[shahleopak]

Syar Brother chlo ap mjh ko simple list ka he bta do jis trha QURAN-E-PAK excel me ha koi b Sorat ko select kro wo sorat ajati ha isi trha me b yehi chata hon koi b name ya A/c no select kro us ki detail ajaye pls ap mjo ko detail se btao or simple list me koi mere elawa changing na kr ske wo protection method b bta
or Index wala method b btana mehrbani ho ge Vlookup wal

pls ho ske to sample sheet bna kr mjh ko email kr den ya PM kr den
Email Id: shahleopak***********
waiting.................

[syar]

Sorry for my late reply. Main Eid ki vacation par tha.


Sample Data Sheet 2 par ha. Aur Formula Sheet 1 per apply keye gae hain.

Agar aap vlookup aur index/match ka drust istimal seekh lain tu aap ko dropdown list ya
User form ki zaroorat nahee pare ge.



Is k elaawa sheet 2 per main ne filter lagaya howa ha. Is m aap jis cell ko bhee muntakhib karain ge baqi data auto select ho gaye ga. Filter lagane ke leye pehle aap apne table ki kisi bhee cell me cursor ko lain aur phir data k tab m ja kar filter par clik karain. Filter apply ho gaey ga.

Mere recomendation ye hoge k aap "Name" ko base banane k bajae A/c No ko base banae kiyon k Name tu aik se zayad duplicate ho sakte hain. Leekan aap apni situation ko behter samajhte hain.



INdex/match aur vlookup (Normal Case) m jo function istimal huwe hain wo genrally istimal hone wale hain. Leekan Vlookup k doosra function jo istimal huwa ha it is special to avoid enter index_number manually


AAp in functin ko deekahin next time m aap ko drop down list banane k method bataon ga. Leekan aap in function se familiar nahee tu please spend sometime on it and if any trouble plaease let me know.

Agar ho sake tu apni file share kar dain. Name aur a/c no change kar lain mujhe sirf ranges check karne hain.


Thanks and regards.