[adinserter block=”1″]

ExcelVLookup #ExcelSwitchFormula #ExcelNestedIf In this tutorial you will learn excel very important concepts relating searching and matching data formulas in a practical way . After completing this , you will be able to apply excel more quickly and can perform jobs in a very short time. Following are the main topics covered in this tutorial :

1. Nested If formulas to Match and Lookup in Excel,
2. Vlookup formula in excel,
3. Very Important and New Formula in Excel Switch formula,
4. Absolute reference and relative reference in excel , a Practical Example to clear the concepts and many more .

Formulas used : Nested if : =IF(A4=1,”JANUARY”,IF(A4=2,”FEBRUARY”,IF(A4=3,”MARCH”,IF(A4=4,”APRIL”,IF(A4=5,”MAY”,IF(A4=6,”JUNE”,IF(A4=7,”JULY”,IF(A4=8,”AUGUST”,IF(A4=9,”SEPTEMBER”,IF(A4=10,”OCTOBER”,IF(A4=11,”NOVEMBER”,IF(A4=12,”DECEMBER”,”INVAILED#”)))))))))))) VLOOKUP : =VLOOKUP(A4,$G$1:$H$13,2,0) Switch : =Switch(A4,1,”JANUARY”,2,”FEBRUARY”,3,”MARCH”,4,”APRIL”,5,”MAY”,6,”JUNE”,7,”JULY”,8,”AUGUST”,9,”SEPTEMBER”,10,”OCTOBER”,11,”NOVEMBER”,12,”DECEMBER”) (Note Switch formula can be used in 2016 or in later versions only) Complete Template can be downloaded from the given link but Plz Don’t forget to Write a positive comment and subscribe our channel to support us for future videos like this.. https://myolesson.com/ Template and complete working file can be downloaded from : https://myolesson.com/ Thanks & Regards : How to Use Nested if || Vlookup || Switch Formulas in Excel Step by Step Urdu Hindi Tutorial

[adinserter block="1"]

Download working file : Top Data Lookup Formulas Nested if Vlookup Switch in Excel Urdu Hindi Tutorial