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)
