Forum Discussion

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
Jul 18, 2020
You should be able to include the headers if you want.

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

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.