

Use MS Excel If/Else Condition






How to Use Excel Functions? Basic Functions of Excel


Use Avarageif Function


Filtering






Use LEFT/RIGHT Function in MS Excel






How to Use VLOOKUP in Excel Step-by-Step Guide?


Use the VLOOKUP function in a table. Example: =VLOOKUP(A2,$A$10:$C$20,2,TRUE) =VLOOKUP(“Excel”,$B$2:$E$7,2,FALSE)


Example if Value Exact Match


Example if Value Approximate Match


Example if Value First Match


Example Two-way lookup


Learn with VLOOKUP Function – Video Minutes ( 41:00)