Forum Discussion

Miguel_Zafiro's avatar
Miguel_Zafiro
Copper Contributor
Jul 18, 2020
Solved

VLOOKUP FORMULA

The formula VLOOKUP consists on this:
=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).

Syntax
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

Now, take a look at the image please, I took that image from
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1


But my question is:

What if instead of putting
"=VLOOKUP(102,A2:C7,2,FALSE)"

You put
"=VLOOKUP(102,A1:C7,2,FALSE)"

So my question is...

What if you decide in the second argument to include the headings of the "table_array"... can you do that?

Can I include the headings of the table in the second argument? Or the formula SHOULD NOT include the headings of the table in the second argument?

Thanks.

Best regards.

excel
Formulas and Functions
  • JMB17's avatar
    JMB17
    Jul 18, 2020
    You should be able to include the headers if you want.

9 Replies

  • TheAntony's avatar
    TheAntony
    Iron Contributor
    Jul 18, 2020

    Miguel_Zafiro , it's a non-issue. The VLOOKUP is just looking for the value 101 and will ignore the heading since it does not have the value 101. 

    • Miguel_Zafiro's avatar
      Miguel_Zafiro
      Copper Contributor
      Jul 18, 2020

      TheAntony Hi!


      Did you take a look at the image "1.png" i attached?

       

      So the formula can work correctly, either if i decide to include the headers, or not?

       

      Because I read a web page in spanish (because that is my native language), in which the person explained that the VLOOKUP formula CANNOT include the headers.

       

      And it was after reading that, that i was no longer sure if the formula could work correctly, either if i decided to include the headers, or not.

       

      But probably the person of that web page was just speaking carelessly without knowing what he was saying.

       

      Thanks for you help

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jul 18, 2020

        Miguel_Zafiro 

        Perhaps the story is about Excel tables. If use something like =VLOOKUP(102,Table1,2,FALSE) headers are not included. But could be added if use =VLOOKUP(102,Table1[#All],2,FALSE) syntax. 

  • JMB17's avatar
    JMB17
    Bronze Contributor
    Jul 18, 2020
    You should be able to include the headers if you want.
    • Miguel_Zafiro's avatar
      Miguel_Zafiro
      Copper Contributor
      Jul 18, 2020

      JMB17 Hi!


      Did you take a look at the image "1.png" i attached?

       

      So the formula can work correctly, either if i decide to include the headers, or not?

       

      Because I read a web page in spanish (because that is my native language), in which the person explained that the VLOOKUP formula CANNOT include the headers.

       

      And it was after reading that, that i was no longer sure if the formula could work correctly, either if i decided to include the headers, or not.

       

      But probably the person of that web page was just speaking carelessly without knowing what he was saying.

       

      Thanks for you help

Resources