Daniel Code

Someone who loves DATA very much

  • Home
  • About Me
  • dAnsas
  • dAnappv2
  • dAnExcel
  • D3.js Chart

03/12/2014

[Excel]vlookup + match (matrix lookup)

=VLOOKUP ( lookup value , table_array , col_index_num , [range_lookup] )
=MATCH ( lookup value , lookup_array , [match _type] )



from http://www.mbaexcel.com/excel/how-to-use-vlookup-match/
Newer Post Older Post Home

Blog Archive

  • ►  2016 (9)
    • ►  Jun (1)
    • ►  Feb (6)
    • ►  Jan (2)
  • ►  2015 (17)
    • ►  Dec (5)
    • ►  Oct (1)
    • ►  Sept (8)
    • ►  Aug (1)
    • ►  May (1)
    • ►  Feb (1)
  • ▼  2014 (11)
    • ▼  Dec (8)
      • [Data Mining]Manhattan distance
      • [SAS]Function
      • [Teradata]Parameterized Macro
      • [SAS]Distinct 用法
      • [SAS]SAS techniques
      • [SAS]Insight
      • [Excel]index+match+match(matrix lookup with no lim...
      • [Excel]vlookup + match (matrix lookup)
    • ►  Nov (3)

Tag

SAS (11) D3.js (5) Excel (4) R (3) DOS command (1)
Simple theme. Powered by Blogger.