Cross-table queries using the VLOOKUP function

Before writing a post about VLOOKUP, http://nearlv.blog.51cto.com/2432295/1120465, actually found in peacetime work, the use of this function is really a lot of, today again to introduce the use of this function.

Today's example is a bit different from the previous one, which is in a workbook, and the next one is to implement a reverse query across the "Workbook".

Work thin one has two fields, employee number, Chinese name, as follows:

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/Office/excel/

Work thin Two, have serial number, room number, employee number and so on several fields, as follows: