Basics of the VLOOKUP Function

A Typical VLOOKUP Function Looks like this:

 

=VLOOKUP(A10,‘sheetname’!$C$1:$L$199,5,0)

 

  • A10 – You input
  • ‘sheetname’! – the sheet that contains your desired data
  • $C$1:$L&199 – coordinator of the data been searched
  • 5 – column number that in the searched area you want to output
  • 0 – match mode
标准差是方差的算术平方根
标准差描述了一组数值自平均值分散开来的程度
方差是各个数据与平均数之差的平方的和的平均数

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s