How to extract A thin work listed in table 1 k X line data-CodePudding

I have 30 working thin, thin there are 12 tables, each work to the data in the K column, A listed as employee name, now I want to create A new work sheet, A list of employee zhang SAN data will be automatically extracted, how to do, thank you teacher, urgent need,
Thin work is as follows:

Serial number name post salary job seniority pay wages bonuses regional allowances
Zhang SAN 10 9 10 11 25
Li si 15 to 20 8 July 10

Serial number name post salary job seniority pay wages bonuses regional allowances
Li si 15 to 20 8 July 10
Zhang SAN 10 9 10 11 25

Zhang SAN
Post salary 10
Post salary 25
Seniority pay 10
Regional allowances 9
Bonus 11

CodePudding user response:

Using VLOOKUP

=VLOOKUP (" zhang ", "table a"! $A $2: $250, $K, FALSE)

CodePudding user response: