VLOOKUP formula to find multiple values from a Table - Malayalam Tutorial

  Рет қаралды 20,113

XL n CAD Malayalam

XL n CAD Malayalam

2 жыл бұрын

എക്സലിലെ VLOOKUP ഫോർമുല ഉപയോഗിച്ച് ഒന്നിലധികം വാല്യൂസ് കണ്ടെത്തുന്നതെങ്ങനെ?
How to VLOOKUP formula to find multiple values in Excel, explained in Malayalam.
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
www.udemy.com/course/microsof...
Download Workbook
xlncad-my.sharepoint.com/:f:/...
Subscribe to the channel for more
/ ajayanandxlncad
#ExcelMalayalam #MalayalamExcel #MalayalamTutorial

Пікірлер: 47
@challengepg8325
@challengepg8325 2 жыл бұрын
Superb trick. 2 varsham munne kandirunnenkil ithu orupaadu upakaaramaayirunnene... Thanks for this great information.... Stay blessed..
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Thank you :)
@saheermangalam8710
@saheermangalam8710 2 жыл бұрын
കട്ട waiting ആയിരുന്നു 👍
@internationalstudentsgatew4011
@internationalstudentsgatew4011 2 жыл бұрын
What a man this is. Well done💡💡👏👏
@hamsakallambalam6684
@hamsakallambalam6684 2 жыл бұрын
Sir, Survey level field book um athinte cross section um oru video cheyyan pattumo
@muhammedmusthafakp8002
@muhammedmusthafakp8002 10 күн бұрын
Ur presentation nice
@swathidevs3150
@swathidevs3150 2 жыл бұрын
Sir, you are magnificent in so many ways..! In fact this is my first comment to your's channel. Every content that you made so far was extremely useful. I found it really worthy and are learning the things to master in it. ❤️
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Thank you for your kind words :)
@manuprasadkl-0686
@manuprasadkl-0686 6 ай бұрын
same name ulla randu peru vannal marku eathu reflect cheyyum ? for eg: hana physics mark 61 aa same name il hana mark 45 ithil eathavum select aavunnthu ?
@vishnusoman8532
@vishnusoman8532 2 жыл бұрын
Can we use countifs function here
@muneermohammed9512
@muneermohammed9512 2 жыл бұрын
Set 👍
@shijilganga5319
@shijilganga5319 2 жыл бұрын
Excellent tips... Thanks a lot
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
You are welcome :)
@pal5395
@pal5395 11 ай бұрын
sir, why do you select 2 in the 3rd example whereby you used choose. since mark is column 3, normally we select 3?
@gopu-kochattan
@gopu-kochattan 2 жыл бұрын
ഒത്തിരി ഇഷ്ട്ടം
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Glad to hear that :)
@jinilms8058
@jinilms8058 2 жыл бұрын
👌👌👌
@aslam1220
@aslam1220 2 жыл бұрын
Very Useful 👍👍👍👍👍
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Thank you :)
@simisuresh7700
@simisuresh7700 2 жыл бұрын
Can we search the HSN code GST rate and rate of a stock item using a single vlookup function
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Please refer the second example shown in the video.
@vallavilasreekumar4420
@vallavilasreekumar4420 2 жыл бұрын
Useful tutorial
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Thank you :)
@KVKtoWorld
@KVKtoWorld 2 жыл бұрын
Very Good presentation 👍🏻
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Thank you :)
@arundineshkotta345
@arundineshkotta345 2 жыл бұрын
👍👍
@elizabethcninan2137
@elizabethcninan2137 2 жыл бұрын
Great 👏
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Thank you :)
@sanveersanu2336
@sanveersanu2336 2 жыл бұрын
😍
@spiderways2178
@spiderways2178 2 жыл бұрын
👍 lookup and Index woooooo ethra hard akhunno athreyum perfection kittum I like that 😀😀😀😀😀 sir ur class karanam onnum markkilla
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Glad to hear that :)
@nasarkk9419
@nasarkk9419 2 жыл бұрын
Thanks
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
My pleasure :)
@kmanoj392
@kmanoj392 2 жыл бұрын
Good
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Thanks
@sunuvinu007
@sunuvinu007 2 жыл бұрын
ഇത്രേം ഒക്കെ എങ്ങനെ പഠിച്ചു എടുക്കും 🙏ഈശ്വര... എന്നാലും ശ്രമിക്കാം ❤മാക്സിമം
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Wish u all the best :)
@siyas1999
@siyas1999 2 жыл бұрын
Datedif ഉപയോഗിച്ച് ഉണ്ടാക്കിയ 2years 3months 10 days എന്നത് 2.3 എന്നു ആക്കാൻ പറ്റുമോ
@rahulravi666
@rahulravi666 2 жыл бұрын
Divided by 365 koduthal mathi
@vineethvinu8654
@vineethvinu8654 2 жыл бұрын
Same Value Repeat ചെയ്തു വരുകയാണെങ്കിലൽ എല്ലാം വരാൻ വേറേ എന്തെങ്കിലും വഴിയുണ്ടോ?
@saheermangalam8710
@saheermangalam8710 2 жыл бұрын
ഒരു sales or Purchase Report ഇല്‍ നിന്നും രണ്ട് തിയ്യതി കളുടെ ഇടയിലുള്ള sales or purchase lookup ചെയ്യാൻ എന്താണ് മാര്‍ഗം
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
The new FILTER function in Excel can be used for this task.
@bhagooavd
@bhagooavd 2 жыл бұрын
VLOOK ഉപയോഗിച്ച് രണ്ട്‌ (A4 and B4) കോളത്തിൽ ഉള്ള നമ്പേഴ്സ് വേറൊരു ഷീറ്റിൽ നിന്നും കണ്ടുപിടിക്കാൻ പറ്റുമോ ? ഇല്ലെങ്കിൽ അങ്ങനെ കണ്ടുപിടിക്കാൻ പറ്റുന്ന വല്ല ഫോർമുലയും ഉണ്ടോ ?
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Please check the following video. kzbin.info/www/bejne/mnmmq2Sgh7SGjrs
@bhagooavd
@bhagooavd 2 жыл бұрын
@@XLnCADMalayalam സർ വീ ലുക്ക് അപ്പ് ദിസ് വാല്യൂ ഓർ ദാറ്റ് വാല്യൂ Vlookup(*A1,B1*,table_array,columnindex,false) ഞാൻ ഉദ്ദേശിക്കുന്നത് രണ്ട്‌ കോളത്തിൽ ഉള്ള ഏതെങ്കിലും ഒരു വാല്യൂ ഒരു അറെയിൽ നിന്നും കണ്ടെത്താൻ വല്ല വഴിയും ഉണ്ടോ എന്നാണ് ??
@Rkr13
@Rkr13 2 жыл бұрын
#N/A varunnath
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
#N/A means not available. Please check my video on Formula errors in Excel.
History  of Microsoft Excel - Malayalam Tutorial
6:03
XL n CAD Malayalam
Рет қаралды 5 М.
VLOOKUP formula in Excel - Malayalam Tutorial
20:29
XL n CAD Malayalam
Рет қаралды 28 М.
When You Get Ran Over By A Car...
00:15
Jojo Sim
Рет қаралды 22 МЛН
Who has won ?? 😀 #shortvideo #lizzyisaeva
00:24
Lizzy Isaeva
Рет қаралды 27 МЛН
ОСКАР vs БАДАБУМЧИК БОЙ!  УВЕЗЛИ на СКОРОЙ!
13:45
Бадабумчик
Рет қаралды 4,3 МЛН
7 Ways to Use Vlookup in Excel
16:44
My E-Lesson
Рет қаралды 2,7 МЛН
How to use FILTER function in Excel - Malayalam Tutorial
18:36
XL n CAD Malayalam
Рет қаралды 40 М.
XLOOKUP Function in Excel - Malayalam Tutorial
23:56
XL n CAD Malayalam
Рет қаралды 43 М.
VLOOKUP in Excel - Malayalam Tutorial
16:29
XL n CAD Malayalam
Рет қаралды 126 М.
10 Most Useful Excel Formulas - Malayalam Tutorial
28:05
XL n CAD Malayalam
Рет қаралды 134 М.
Excel VLookup to Return Multiple Matches
6:55
The Excel Cave
Рет қаралды 197 М.
25 Keyboard Shortcuts in Excel - Malayalam Tutorial
17:57
XL n CAD Malayalam
Рет қаралды 135 М.