EXCEL formula application problems

Users questions: Suppose A table has 50 students, the corresponding serial numbers, B the name of the table only students, but no number, what method can be output numbers? (B table A table of students order and not the same as students in order) Thank you!
Experts answer: Yes, use the query function is easy to get out. Please see Annex B Table B set out the formula. Annex: Add number. Xls
  • This information provided by the users.Thanks!