4 views
Excel Hacks- Vlookup
What is Vlookup?
Look for a VALUE in the leftmost column of a TABLE and returns a value in the same row from a column you specify. VLOOKUP scans the selected column until it finds the required item (maybe the name of the employee or product or employee code) and then it gives you the required information related to that item (salary of employee, cost of the product, department of the employee).
Why Vlookup?
The simplest answer is to search. There are other...
Look for a VALUE in the leftmost column of a TABLE and returns a value in the same row from a column you specify. VLOOKUP scans the selected column until it finds the required item (maybe the name of the employee or product or employee code) and then it gives you the required information related to that item (salary of employee, cost of the product, department of the employee).
Why Vlookup?
The simplest answer is to search. There are other...
