VLOOKUP formula in Excel | Malayalam Tutorial
വെറും 5 മിനിറ്റിൽ എക്സലിലെ വിലുക്കപ്പ് ഫോർമുല പഠിക്കാം.
VLOOKUP formula in Excel explained in Malayalam.
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/microsof...
Subscribe to the channel @AjayAnandXLnCAD for more.
/ ajayanandxlncad
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/learn-mi...
1. Partial Match with VLOOKUP in Excel
• Partial Match with VLO...
2. VLOOKUP from two different Tables in Excel
• VLOOKUP from two diffe...
3. 2-Way lookup using VLOOKUP in Excel
• 2 Way lookup using VLO...
4. Combine VLOOKUP Formula with other Excel formulas
• Combine VLOOKUP Formul...
5. Combine Tables using the VLOOKUP function in Excel
• Combine Tables using V...
6. VLOOKUP into Excel Tables - Excel Malayalam Tutorial
• VLOOKUP into Excel Tab...
#excelmalayalam #malayalamtutorial #vlookupmalayalam
Пікірлер: 31
Main problem enthann vecha , suit avunna situation varumbo doubt aahn ,eth equation aahn ivda apply cheyya ennullad, pinne vere functions nte koode cheyyanum ariyathilla🤷
Very best presentation, Sir. Real teaching skill if you is highly appreciated.. We all like your classes
@XLnCADMalayalam
4 ай бұрын
Glad to hear that 😀
Hi.. Suppose in my table the name column is the 3rd column. desg and dept and 1st and 2nd column respectively. How can i write vlookup formula. I had a scenario like that. And I tried to select whole table. Suppose I want designation, what col_index_num I have to give?
Excellent 👏👏👏
Sir nallath pole manasilayi thank u sir
@XLnCADMalayalam
22 күн бұрын
Glad to hear that 😀👍
Informative ❤
Great
Sir nice presentation.......👍👍👍 ആ ചെറിയ കോളത്തിൽ എങ്ങനെ automatic ആയി data entry ആയത്
Thank you 👍🏻
@XLnCADMalayalam
7 ай бұрын
You’re welcome 😊
Thank you sir.
@XLnCADMalayalam
7 ай бұрын
You are welcome 😀
Nice presentation.. ❤ Waiting for VBA Course.
@XLnCADMalayalam
8 ай бұрын
😀👍
Sir good Class ...❤
@XLnCADMalayalam
6 ай бұрын
Glad to hear that 😀
Awesome work 👌
@XLnCADMalayalam
8 ай бұрын
Glad to hear that 😀
Good morning sir. Will you please explain how to add and keep a formula in Excel data form for automation. I made a formula in database, but after accepting the submit button and trying to add another data the formula disappears. I came to understand that you got special awards from Microsoft for the teaching which you are conducting online and at classes. Waiting for your kind reply
@XLnCADMalayalam
6 ай бұрын
VBA for Excel has infinite possibilities and people use it for automation in many different ways. I recommend checking the Excel VBA course on UDEMY by Leila Gharani. I hope your doubts will be cleared, if not you can make use of the Q&A section of the course to ask doubts.
@XLnCADMalayalam
4 ай бұрын
Please check the video description for details of my online course on Excel.
vlookup function work designation against salary nokan pattumo? name vach filter cheyyumbol same name repeat ayal error akille?
@XLnCADMalayalam
7 ай бұрын
There will be many people with same designation. So, it depends on what you want to achieve.
Ee work sheet onnu kittumo cheyth nookan
Sumif and filter combination, oru video cheyyamo.
ടേബിൾ list ഇൽ ഒരു data repeat ആയി വരുന്നതിൽ total amount അങ്ങനെ
@XLnCADMalayalam
Ай бұрын
ചോദ്യം ഉദാഹരണ സഹിതം വ്യക്തമാക്കാമോ? എന്ത് തരത്തിലുള്ള ഡാറ്റയാണ്, എന്താണ് റിസൾട്ട് ആയിട്ട് വേണ്ടത്, അങ്ങിനെയുള്ള കാര്യങ്ങൾ വിശദമാക്കാമോ
ആൽഫബെറ്റ് ഓർഡർ നെയിം
@XLnCADMalayalam
8 ай бұрын
Use SORT Function