VLOOKUP function is one of the most powerfull function in Excel.
We can explain 15 different usage for you.
1. Exact match (typical scenario).
2. Close match (for numbers)
3. Wildcard characters (* and ?)
4. With error control (iferror).
5. With error control (if iserror)
6. Compare two lists
7. With MATHC function. Two dimensional.
8. With ROW function.
9. Winth COLUNN function.
10. With IF function.
11. With LOOKUP function.
12. With CHOOSE function.
13. Winth SUM function. And Array usage.
14. With INDIRECT function.
15. Other usages.
