XLOOKUP with Examples Replace VLOOKUP HLOOKUP Index Match

XLOOKUP Replace VLOOKUP HLOOKUP Index Match
#Excel2019 #ExcelTutor #ExcelMalayalam
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 1 : • Excel 2019 Basic to Ad...
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 2 : • Excel 2019 Basic to Ad...
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 3 : • Excel 2019 Basic to Ad...
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 4 : • Excel 2019 Basic to Ad...
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 5 : • Excel 2019 Basic to Ad...
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 6 : • Excel 2019 Basic to Ad...
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 7 : • Excel 2019 Basic to Ad...
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 8 : • Excel 2019 Basic to Ad...
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 9 : • Excel 2019 Basic to Ad...
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 10: • Excel 2019 Basic to Ad...
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 11: • Excel 2019 Basic to Ad...
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 12: • Excel 2019 Basic to Ad...
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 13: • Microsoft Excel 2019 B...
part 14 sumifs • Excel 2019 Basic to Ad...
part 15 • Microsoft Excel 2019 B...
part 16 • Microsoft Excel2019 Us...

[@CountingCarsmalayalam]

UNDERSTOOD.well done

[@AVTechandTravel]

Thank u

[@tmdasan]

Your classes are very much useful & understable very simply..Thanks.

[@sajil6435]

Kollam..tnx

[@AVTechandTravel]

Most welcome

[@canadiandiary4360]

Thank you for sharing, clear and simple explanation

[@AVTechandTravel]

Welcome🥰❤

[@Rihan-1987]

Gorgeous and excellent

[@AVTechandTravel]

Thank u

[@aneeshaaby1420]

Checking njan ippol advance excel aanu padikunath kondu e videos enniku help cheyunudu thank u so much

[@AVTechandTravel]

Welcome dear🥰

[@praveenjohn3424]

Thanks mam for sharing updated information

[@AVTechandTravel]

Welcome dear🥰

[@mohmdshajith]

VERY NICE MADAM...THANKS, A LOT...

[@AVTechandTravel]

Most welcome

[@treesageorge3729]

Im now your follower of videos and I shared the channel to my friends too. You deserve more subscribers as the content is really helpful for most of the peoples.

[@AVTechandTravel]

Thank you so much for such an inspiring cmnt....🥰😘💕

[@johnunnunny1373]

Really class is good and understandable. Can you explain on data table

[@thoma9181]

Suppose i created an excel 365 file and inside i use Xlook up function and i send this file to my collegue, if he is opening this file in 2019 or lower version how this formula will react? thanks in advance

[@noufalc.m458]

Hi Madam, How to get multiple pdf files which contains more than one pages in power query. ..if you can please share..

[@dennyaugustine2767]

Thank you..

[@AVTechandTravel]

You're welcome

[@mohdmahi6147]

👍👍

[@AVTechandTravel]

🥰

[@ublogs]

i have a question. there are two tables (created with ctrl + t command) on the same sheet in first table there are two headings 1. subject 2. marking type (means particular subject will be awarded grades or marks) (for example there are four subjects i.e. ENGLISH , MATH, DRAWING, SPORTS, MUSIC) [FIRST TWO SUBJECTS WILL BE AWARDED MARKS AND REST OF THREE WILL BE GRADED] now there is second table having one column 1. grading subject aim of creating second table is to show only grading subjects from ist table WHICH ARE DRAWING SPORTS AND MUSIC XLOOKUP NOT WORKING IS THERE ANY OTHER OPTION?

[@AVTechandTravel]

If you have the file plz send it..

[@ublogs]

@@AVTechandTravel I CAN SEND YOU SCREEN SHOT ...BUT THERE IS NO OPTION TO ATTACH

[@ublogs]

A1=SUBJECT A2=MATH A3=ENGLISH A4=MUSIC A5=DRAWING B1=GRADING B2=NO B3=NO B4=YES B5=YES C1=MARKS C2=100 C3=80 C4=50 C5=30 ABOVE IS DATA OF TABLE ONE. AND THIS DATA IS CONVERTED INTO TABLE BY PRESSING CTRL.+T NOW WHAT IS REQUIRED IS TO CREATE A NEW TABLE WITH SUBJECTS WHICH ARE GRADING SUBJECTS ONLY. [YES] F1=SUBJECT F2=MUSIC F3=DRAWING G1=MARKS G2=50 G3=30 ONE LAST THING IS TO ADD MARKS OF NON GRADING SUBJECT VIA FORMULA.

[@AVTechandTravel]

Make sure that u r using office 365... not 2019 or 16 You can type grading subjects.. then use xlookup to return marks...

[@ublogs]

@@AVTechandTravel PLEASE SHARE STEPS OR VIDEO RELATED THIS PROBLEM