American Broadcasting Company Inc (ABC)
1 Zhang Sanmen 20 1 Wang formula
2 Liu Na female 2 1 2 Liu Bin formula
3 Wang Nv 102 3 Peng Pai Formula
4 San Mao Nan 10
5 Liu Bin men 6
6 Wang Xiaohu male 7
7 Peng Pai male 10
8 dog egg man 8
9 Little Snow Girl 22
Enter the formula in column B 1 in table 2:
=VLOOKUP(A 1, table 1! A 1:B9,2,false)
In this way, Wang's gender will be displayed in B 1
The content of the formula is like this. Vlookup is the search function of excel, and the value you are looking for is the first one in brackets. Here we refer to the content in A 1, that is, Wang, and then separate it with ",". The second parameter is the search range, which is the range we want to find it. Of course, we use A 1 to B9 in the table1here. Why use column b? After the search range is marked, it is also separated by ",",and then the column number of the return value, that is to say, after finding the name of the person you are looking for, here we also take Wang as an example. To find the queen in a 1 to B9 of table1,the value we need to return is the last column of the king column, because we want to display the gender, which is the name in the range we are looking for. This is why the second column should be included in the search scope. The last parameter, the fuzzy search function, is generally set to false, and we only look for the exact match, that is, the appointment must be exactly the same to be valid.
I don't know if it's okay to say this. It should be noted that the contents of table 1 and the columns you are looking for must be arranged in ascending order. This must be noted. If you want to display the age together, expand the search scope to A 1 to C9, and the returned column number will become 3.