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

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

XL n CAD Malayalam

XL n CAD Malayalam

Күн бұрын

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

Пікірлер: 50
@challengepg8325
@challengepg8325 3 жыл бұрын
Superb trick. 2 varsham munne kandirunnenkil ithu orupaadu upakaaramaayirunnene... Thanks for this great information.... Stay blessed..
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Thank you :)
@saheermangalam8710
@saheermangalam8710 3 жыл бұрын
കട്ട waiting ആയിരുന്നു 👍
@swathidevs3150
@swathidevs3150 3 жыл бұрын
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 3 жыл бұрын
Thank you for your kind words :)
@gopu-kochattan
@gopu-kochattan 3 жыл бұрын
ഒത്തിരി ഇഷ്ട്ടം
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Glad to hear that :)
@internationalstudentsgatew4011
@internationalstudentsgatew4011 2 жыл бұрын
What a man this is. Well done💡💡👏👏
@deepugeorge2851
@deepugeorge2851 2 ай бұрын
sir thank you so much
@XLnCADMalayalam
@XLnCADMalayalam 2 ай бұрын
😀👍
@muhammedmusthafakp8002
@muhammedmusthafakp8002 3 ай бұрын
Ur presentation nice
@shijilganga5319
@shijilganga5319 3 жыл бұрын
Excellent tips... Thanks a lot
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
You are welcome :)
@hamsakallambalam6684
@hamsakallambalam6684 3 жыл бұрын
Sir, Survey level field book um athinte cross section um oru video cheyyan pattumo
@spiderways2178
@spiderways2178 3 жыл бұрын
👍 lookup and Index woooooo ethra hard akhunno athreyum perfection kittum I like that 😀😀😀😀😀 sir ur class karanam onnum markkilla
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Glad to hear that :)
@KVKtoWorld
@KVKtoWorld 2 жыл бұрын
Very Good presentation 👍🏻
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Thank you :)
@muneermohammed9512
@muneermohammed9512 3 жыл бұрын
Set 👍
@aslam1220
@aslam1220 3 жыл бұрын
Very Useful 👍👍👍👍👍
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Thank you :)
@vallavilasreekumar4420
@vallavilasreekumar4420 3 жыл бұрын
Useful tutorial
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Thank you :)
@vishnusoman8532
@vishnusoman8532 2 жыл бұрын
Can we use countifs function here
@fahaderamban5492
@fahaderamban5492 Ай бұрын
Time 8.21 മിനിറ്റിൽ colemn index number 2 എന്നത് പറഞ്ഞത് മനസ്സിലായില്ല?.. അതെങ്ങനെ? choose function ഫോർമുല ഉള്ളത്?
@elizabethcninan2137
@elizabethcninan2137 3 жыл бұрын
Great 👏
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Thank you :)
@nasarkk9419
@nasarkk9419 3 жыл бұрын
Thanks
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
My pleasure :)
@sunuvinu007
@sunuvinu007 3 жыл бұрын
ഇത്രേം ഒക്കെ എങ്ങനെ പഠിച്ചു എടുക്കും 🙏ഈശ്വര... എന്നാലും ശ്രമിക്കാം ❤മാക്സിമം
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Wish u all the best :)
@manuprasadkl-0686
@manuprasadkl-0686 9 ай бұрын
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 ?
@saheermangalam8710
@saheermangalam8710 3 жыл бұрын
ഒരു sales or Purchase Report ഇല്‍ നിന്നും രണ്ട് തിയ്യതി കളുടെ ഇടയിലുള്ള sales or purchase lookup ചെയ്യാൻ എന്താണ് മാര്‍ഗം
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
The new FILTER function in Excel can be used for this task.
@kmanoj392
@kmanoj392 2 жыл бұрын
Good
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Thanks
@pal5395
@pal5395 Жыл бұрын
sir, why do you select 2 in the 3rd example whereby you used choose. since mark is column 3, normally we select 3?
@simisuresh7700
@simisuresh7700 3 жыл бұрын
Can we search the HSN code GST rate and rate of a stock item using a single vlookup function
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Please refer the second example shown in the video.
@jinilms8058
@jinilms8058 3 жыл бұрын
👌👌👌
@vineethvinu8654
@vineethvinu8654 3 жыл бұрын
Same Value Repeat ചെയ്തു വരുകയാണെങ്കിലൽ എല്ലാം വരാൻ വേറേ എന്തെങ്കിലും വഴിയുണ്ടോ?
@bhagooavd
@bhagooavd 3 жыл бұрын
VLOOK ഉപയോഗിച്ച് രണ്ട്‌ (A4 and B4) കോളത്തിൽ ഉള്ള നമ്പേഴ്സ് വേറൊരു ഷീറ്റിൽ നിന്നും കണ്ടുപിടിക്കാൻ പറ്റുമോ ? ഇല്ലെങ്കിൽ അങ്ങനെ കണ്ടുപിടിക്കാൻ പറ്റുന്ന വല്ല ഫോർമുലയും ഉണ്ടോ ?
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Please check the following video. kzbin.info/www/bejne/mnmmq2Sgh7SGjrs
@bhagooavd
@bhagooavd 3 жыл бұрын
@@XLnCADMalayalam സർ വീ ലുക്ക് അപ്പ് ദിസ് വാല്യൂ ഓർ ദാറ്റ് വാല്യൂ Vlookup(*A1,B1*,table_array,columnindex,false) ഞാൻ ഉദ്ദേശിക്കുന്നത് രണ്ട്‌ കോളത്തിൽ ഉള്ള ഏതെങ്കിലും ഒരു വാല്യൂ ഒരു അറെയിൽ നിന്നും കണ്ടെത്താൻ വല്ല വഴിയും ഉണ്ടോ എന്നാണ് ??
@arundineshkotta345
@arundineshkotta345 3 жыл бұрын
👍👍
@sanveersanu2336
@sanveersanu2336 3 жыл бұрын
😍
@Bullish-y7v
@Bullish-y7v 3 жыл бұрын
Datedif ഉപയോഗിച്ച് ഉണ്ടാക്കിയ 2years 3months 10 days എന്നത് 2.3 എന്നു ആക്കാൻ പറ്റുമോ
@rahulravi666
@rahulravi666 3 жыл бұрын
Divided by 365 koduthal mathi
@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 М.
XLOOKUP Function in Excel - Malayalam Tutorial
23:56
XL n CAD Malayalam
Рет қаралды 45 М.
SHAPALAQ 6 серия / 3 часть #aminkavitaminka #aminak #aminokka #расулшоу
00:59
Аминка Витаминка
Рет қаралды 2,3 МЛН
Power Pivot in Excel - Malayalam Tutorial
10:30
XL n CAD Malayalam
Рет қаралды 7 М.
How to Use VLOOKUP to Compare Two Lists
15:20
Simon Sez IT
Рет қаралды 829 М.
VLOOKUP formula in Excel - Malayalam Tutorial
20:29
XL n CAD Malayalam
Рет қаралды 29 М.
Index Match Formula in Excel - Malayalam Tutorial
9:09
XL n CAD Malayalam
Рет қаралды 33 М.
Pivot Table in Excel - Malayalam Tutorial
16:17
XL n CAD Malayalam
Рет қаралды 224 М.
How to Use VLOOKUP in Excel (free file included)
15:15
Leila Gharani
Рет қаралды 242 М.
SHAPALAQ 6 серия / 3 часть #aminkavitaminka #aminak #aminokka #расулшоу
00:59
Аминка Витаминка
Рет қаралды 2,3 МЛН