Pay scale grade medha oka video cheygalaru..... A B C D A▶️15000-100-16000-110-17100 B▶️20000-125-21250-+135-22600 Ela unaa basic medha grade prakaram apply cheyali....... Govt jobs pay band scale and grades....
Hello Sir office work lo vlookup formula Ela undi ante oka column cell lo heading petti akkada vlookup formula chesi another sheet lo unna data chala ekkuva data undi aa table array motham okate sari select kaavatledu sheet lo ki ravadaaniki. Ela select cheyali chepandi.
sir, i request you very fruitfully, plz do one or two example with vlookup+match from sheet1 - sheet2 find out result. if you can am very full fill my doubt and clear. Emp ID, Name, Dept.Name, No of present, no of absent , Salary amount, Advance Salary... out put: Lookup value : Emp ID, Result required : Dept.Name, Salary amount, Advance Salary with vlookup+match formula
Ok Thanks for good teaching Sir...But Small doubt yearly wise data How to display using vlookup formula... Example: 2019-20 (Available classes 4rth,5th classes ).... Select 2019-20 & Select class 4rth now display 4rth class pupils data ,Same way Select 2019-20 & 5th class display 5th class pupils details... Available any possible Sir like above video concept...
Huge data unnapudu, veroka sheet lo konni emp id lu unnapudu, vlookup function use chestu, remaining details ni find out cheyyali... meru ee vedio lo names define chesaru kada,ala ravadam ledhu sir...
Bro letters type chesetappudu space echinappudu first word ni captil lo 2nd word s small letters type cheyalantay ebbandi ga undi total ni select chesi yedo chestaruga adi konchem cheppandhi
nenu practice cheste vamchimdhi ... but employe no. lo number tho alphabet letters iste work avvadam ledu.. ex: emp no. 101cse , 201eee, like that... so how to work ???
Above Topic Excel Format File Link below :-
----------------------------------
www.computersadda.com/2020/03/x-lookup-function-in-ms-excel-practice-file/
=================
Very useful video who works in excel sheets
Your explanation with that level of patience just blow my mind👍
Thanks anna Mee videos chusi nen vlookup nerchukunttumnanu
Very useful information. Thank you so much for sharing with us sir ❤
Thank you for your explanation sir, it's successful work for me
How to apply formulas pls oka video cheyandi sir..me classes carrier build చేయడానికి చాలా use అవుతుంది సిర్ తనకు
Excellent coaching
Your explanation is really good.. i like it.. Tq
Plz make a video on how to make credit card entries in tall erp 9 and shares purchase and sale
Thanks
Focus gurinchi explain chayandi.
Thank s for your information sir but
We need to do multiple sheets in same data how to identify please explain sir 🙏
Thanks Anna nee valla job ki chances perigayi
Thanks for the this video sir pivot table pina oka video sir...
Sir,if you possible could you do one more vedio about vlookup n how to do vlookup formula from other sheet n how to remove duplicates...
Excellent bro.....
THANKYOU FOR DOWNLOADED FILES
Very good information video. Thanks 🙏
Sir naku oka dout
Direct ga Direct applychesta saripodni kadha
thank you good explanation sir
Excellent sir ... Tq u sir
wow.......what an explanation
Excellent sir.
Very useful man
Bro,
Your explanation was damn good.
excellent video 👌👌👌
Thanks you so helpful
Thanks for the helpful video Sir.
Thank you so much sir
Super
Tq a lot, waiting for this video from long time.
Finally I got this video
SIR WHEN WE are using initially if statements it is coming as very few arguments are used
If first column is emp name instead of emp no what we should provide in formula after lessthan or equal to
Waiting for c language sir.
Hlookup gurinchi full video kavalisir
Sir, pls explain power Bi program
Pay scale grade medha oka video cheygalaru.....
A B C D
A▶️15000-100-16000-110-17100
B▶️20000-125-21250-+135-22600
Ela unaa basic medha grade prakaram apply cheyali.......
Govt jobs pay band scale and grades....
Hello Sir office work lo vlookup formula Ela undi ante oka column cell lo heading petti akkada vlookup formula chesi another sheet lo unna data chala ekkuva data undi aa table array motham okate sari select kaavatledu sheet lo ki ravadaaniki. Ela select cheyali chepandi.
Thank you
sir, i request you very fruitfully, plz do one or two example with
vlookup+match from sheet1 - sheet2 find out result. if you can am very full
fill my doubt and clear. Emp ID, Name, Dept.Name, No of present, no of absent , Salary amount, Advance Salary...
out put: Lookup value : Emp ID, Result required : Dept.Name, Salary amount, Advance Salary with vlookup+match formula
Anna vlookup vaadi master sheet lo vunna data pakkana mana refference sheet avasaramina vatine thisukovalnte okasari chepandi leda video cheyandi.
Emp no same unte next ela filter cheyalee sirr
Employees code sequence ga lekapothe ascending lo vunte ela brother please explain
Good informative...also for making header dynamic we can use match function instead of giving each time number for various headers
Meeru supppprb sir 🙏🏼
Make more videos on vlookup 🙏
Thanks
Should the particulars of Vlookup table and finding data table be with same column position?
Sir please tell me what is pgdca course
Ok Thanks for good teaching Sir...But
Small doubt yearly wise data How to display using vlookup formula...
Example: 2019-20 (Available classes 4rth,5th classes )....
Select 2019-20 & Select class 4rth now display 4rth class pupils data ,Same way Select 2019-20 & 5th class display 5th class pupils details... Available any possible Sir like above video concept...
Good job anna 🙏
Well sir
Can we use this formula for google sheets also?
Sir can u teach me complete Excel , if yes how many days it will take , What will be the fee
Tq sir...good videos
Huge data unnapudu, veroka sheet lo konni emp id lu unnapudu, vlookup function use chestu, remaining details ni find out cheyyali... meru ee vedio lo names define chesaru kada,ala ravadam ledhu sir...
Hi bro can u please make 1 video how to change the existingdata range for name manager or tables please sugges
How to transfer the data from cash book to ledger in excel sheet
Tq sir
SIR Upload Python Videos ALSO
Good
Sir everything is fine but the lookup value is not a number then how can we use if function here? Kindly answer me
Good night sir,
super sir
Sir total values Ni Ela chayali sir please explain chayandi sir
Thanks sir
Hi sir can you please do sap mm videos
Excel sheet lo tabul multify aka cheyali anna
Super excited
If duplicate rows will it work
Thank you annaya
GOOD , PLEASE TELL HOW TO LINK DATA IN ONE EXCEL SHEET LINK TO ANOTHER SHEET WHILE PREPARING REPORT CARD OF STUDENTS
🙏thanku sami
Durga prasad garu I press f4 but it can't freezed. can you pls help me?😔what will I do for that.
Sir namaste please make video for combine multiple excel sheets into one sheet
Consolidation option vadandi
3 tables కి. ఈ formula work avvuddha ??
*=Vlookup(A3,IF(A3
No
Sir multiple sheets nunchi check chestunnappduu last lo true false ani mention cheyyakkarleda?
Sir id alphabet cum numerical unty ela work cheyali
Thank you sir
Anna Hlookup link unte naku pettu anna 😊
Adobe premiere pro apudu start chestaru sir ??
🤚👍
Exel lo salary sheet next sheet lo pay slip తయారు చేయటం ఎలా నేర్పా గలారు
Ok
One sheet lo data two or three same entryes how to find double triple entry s
BROTHER EXCEL DATA BRANCH WISE & CAST WISE QUALIFIED STUDENT COUNT FORMULA PLEASE
Dear, A3 varaku maatrame cheppparu, okavela A4 lo alaage A5,6,7 kavalante elaga, drag cheste formula apply kavatam ledu
There is no data in A5, 6,7
Can we save vlookup formula data permanently. If yes make comment n how 😊
Bro letters type chesetappudu space echinappudu first word ni captil lo 2nd word s small letters type cheyalantay ebbandi ga undi total ni select chesi yedo chestaruga adi konchem cheppandhi
Word or Excel
Word lo bro
Mi video lo chusanu kaani marachipoyanu
nenu practice cheste vamchimdhi ... but employe no. lo number tho alphabet letters iste work avvadam ledu.. ex: emp no. 101cse , 201eee, like that... so how to work ???
If employee id is a character
Giving column number manually is not advisable
Sheet name define chesanu. But formula echetappudu drop down lo nenu define chesina name kanipinchandam ledhu
How to add multiple excel sheets in one excel sheet..... please do one vedio
Already chesanu channel lo Chundandi
Department wise display kavalante mottam data
Daybook cheyandi
Sir A3 freeze avtledhu.F4 kottina avtledhu.
Anna Naku konni douts undi anna
volume very low .plz increase the sound
Link yee ledhu bro
Sir more than 3 sheets unnappudu formula ela veyaali sir
Multiple if conditions use cheyandi
Thank you sir