How do you find a way to find information about employees or goods.
How do you find a way to find information about employees or goods.
At the same time, we have a lot of goods, but there is no such quick navigation method today,
let's show quick search methods through the Excel Lessons.
First, we need to have a managerial chart, a staff member, or a product management booth
For example, I have the following table
| Column A | Column B | Column C | Column D | Column E | |
| row 1 | ID | Name | Gender | Position | Salary |
|---|---|---|---|---|---|
| row 2 | 1 | A | Male | Teacher | $ 200.00 |
| row 3 | 2 | B | Female | Staff | $ 200.00 |
| row 4 | 3 | C | Male | Teacher | $ 200.00 |
| row 5 | 4 | D | Female | Teacher | $ 200.00 |
| row 6 | 5 | E | Male | Teacher | $ 200.00 |
Table 2
| Column A | Column B | Column C | Column D | Column E | |
| row 1 | ID | Name | Gender | Position | Salary |
|---|---|---|---|---|---|
| rows 2 | =Vlookup(A2, Select Table 1 both , 2 | =Vlookup(A2, Select Table 1 both , 3 | =Vlookup(A2, Select Table 1 both , 4 | =Vlookup(A2, Select Table 1 both , 5 |
If you do not understand, you can visit this video by clicking on the link below , My Video
You've Got My Video Yes. Thank you
