excel vlookup 样例

Sure, here is an example of using the VLOOKUP function in Excel:

Assume we have a table of employee information, with columns for employee name and salary. We also have a separate table with sales information, including the employee name and their sales figures. We want to add a column to the sales table that looks up each employee's salary based on their name.

To do this, we would use the VLOOKUP function. The formula would look something like this: =VLOOKUP(employee name, range containing employee name and salary, column containing salary, 0)

For example, if our employee information table is in A1:B10, and our sales information table is in D1:E10, our formula might look like this: =VLOOKUP(D2,$A$1:$B$10,2,0)

This would search the employee information table for the name listed in cell D2 (the first employee listed in the sales table), and return the corresponding salary from the second column of the employee table.