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 (F...
excel
Formulas and Functions
  • JMB17's avatar
    JMB17
    Jul 18, 2020
    You should be able to include the headers if you want.
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