Excel table VLOOKUP function

=vlookup (a3,sheet1! a:f,3,0)

Get third-party data for the same data in two sheet,

First Sheet1 is the source data, Sheet2 is the data to be generated empty shelves

In Sheet2 the table that needs to generate the data is inserted into the =vlookup (a3,sheet1! a:f,3,0)

VLOOKUP (reference needs to be compared to the column, compared to the data range, the data to be obtained after the Comparison column table starting from 1, the exact 0 alignment or Blur 1 ratio pair)

=vlookup (a3,sheet1! a:f,3,0)

Explain

A3: Reference, need to compare the column

sheet1! A:F: Comparison data range

3: Data for data columns that need to be fetched after comparison, the following table starts from 1

0: Exact 0 false, Blur 1 true

This article is from the "Intelligent Future _XFICC" blog, please be sure to keep this source http://xficc.blog.51cto.com/1189288/1684553

Excel table VLOOKUP function