[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 :
Nested If formulas to Match and Lookup in Excel,
Vlookup formula in excel,
Very Important and New Formula in Excel Switch formula,
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