EXCEL系列文章目录

  Excel系列文章是本人亲身经历职场之后萌发的想法,为什么Excel覆盖如此之广,几乎每个公司、学校、家庭都在使用,但是它深藏的宝藏功能却很少被人使用,PQ、BI这些功能同样适用于数据分析;并且在一些需要简单及时的数据分析项目前,Excel是完胜python、R、SPSS这些科学专业的软件的.因此决心开启Excel篇章.

数据分析为什么要学Excel
Excel图表美化—表格美化
Excel函数公式大全—IF函数
Excel函数公式大全—IF家族函数
Excel函数公式大全—VLOOKUP函数
Excel函数公式大全—MATCH函数

前言

  Someone always remembers number one,And ignore the existence of the second place;As most people know, the first man to walk on the moon was Armstrong,But few people know about Buzz·Aldrin was the second man to walk on the moon.
  在excelThis is also the case in the world of formulas,The king of functions has been published beforeVLOOKUP()函数,I believe many people are very familiar with this function;But its sibling functionHLOOKUPThe popularity has been greatly reduced.This article will lead you closerHLOOKUP,Let me show you the difference between the two brothers.也希望大家将想学习了解的函数留言 ,在后面的文章里我们一起学习分享 ！

一、HLOOKUP函数语法

HLOOKUP(lookup_value,table_array,row_index_num,[range_lookup])
HLOOKUP( 查找的内容 ,查找区域 , 第几行,查找方式）

• HLOOKUP 指定条件在指定区域横方向查找

示例：
=HLOOKUP(“轴承”, A1:C4, 3, FALSE)    *Find the bearing on the first row,and return the same column（列 B）中第 3 行的值. *
=HLOOKUP(“螺栓”, A1:C4, 4)   Look for the bolts in the first row,and return the same column（列 C）中第 4 行的值.
=HLOOKUP(3, {1,2,3;“a”,“b”,“c”;“d”,“e”,“f”}, 2, TRUE)   Find a number in a three-line array constant 3,and return the same column（In this case it is the third column）中第 2 行的值. There are three rows of values ​​in the array constant,And use semicolons on each line ( ; ) 分隔. 因为在第 2 行和第 3 列（同一列）中找到 c,因此将返回 c.

二、图解算法

公式解释：in the selected area,Find column name equals “数学” 对应的第9行的值.

三、对比VLOOKUP

  Comparing the two pictures can be seen,The parameters of the formula are basically the same,Take the lookup value, respectively、查找范围、第几行or列、匹配方式.Enough to see the similarity between the two brothers,The real difference is the inner logic of how the formula works;Both their personalities are inconsistent.One likes sweet,One likes spicy,One is North,One is the South.正是因为这样的关系,This has led to the survival of the fittest in the waves of history for the two formulas.
  in most forms,展现过程中,Usually stored in the form of columns,这使得VLOOKUP的使用越来越多,也使得HLOOKUP无用武之地.

总结

  HLOOKUPIt's just rarely used in most forms,But I still hope you can understand,for later needs,It is also an accumulation.博观而约取,厚积而薄发！

  也希望大家将想学习了解的函数留言 ,在后面的文章里我们一起学习分享 ！