SOLVED

VLOOKUP FORMULA

%3CLINGO-SUB%20id%3D%22lingo-sub-1530384%22%20slang%3D%22en-US%22%3EVLOOKUP%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530384%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20formula%20VLOOKUP%20consists%20on%20this%3A%3CBR%20%2F%3E%3DVLOOKUP(lookup%20value%2C%20range%20containing%20the%20lookup%20value%2C%20the%20column%20number%20in%20the%20range%20containing%20the%20return%20value%2C%20Approximate%20match%20(TRUE)%20or%20Exact%20match%20(FALSE)).%3C%2FP%3E%3CP%3ESyntax%3CBR%20%2F%3EVLOOKUP%20(lookup_value%2C%20table_array%2C%20col_index_num%2C%20%5Brange_lookup%5D)%3C%2FP%3E%3CP%3ENow%2C%20take%20a%20look%20at%20the%20image%20please%2C%20I%20took%20that%20image%20from%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EBut%20my%20question%20is%3A%3C%2FP%3E%3CP%3EWhat%20if%20instead%20of%20putting%3CBR%20%2F%3E%22%3DVLOOKUP(102%2CA2%3AC7%2C2%2CFALSE)%22%3C%2FP%3E%3CP%3EYou%20put%3CBR%20%2F%3E%22%3DVLOOKUP(102%2CA1%3AC7%2C2%2CFALSE)%22%3C%2FP%3E%3CP%3ESo%20my%20question%20is...%3C%2FP%3E%3CP%3EWhat%20if%20you%20decide%20in%20the%20second%20argument%20to%20include%20the%20headings%20of%20the%20%22table_array%22...%20can%20you%20do%20that%3F%3C%2FP%3E%3CP%3ECan%20I%20include%20the%20headings%20of%20the%20table%20in%20the%20second%20argument%3F%20Or%20the%20formula%20SHOULD%20NOT%20include%20the%20headings%20of%20the%20table%20in%20the%20second%20argument%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3EBest%20regards.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1530384%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530412%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530412%22%20slang%3D%22en-US%22%3EYou%20should%20be%20able%20to%20include%20the%20headers%20if%20you%20want.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530479%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530479%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F726406%22%20target%3D%22_blank%22%3E%40Miguel_Zafiro%3C%2FA%3E%26nbsp%3B%2C%20it's%20a%20non-issue.%20The%20VLOOKUP%20is%20just%20looking%20for%20the%20value%20101%20and%20will%20ignore%20the%20heading%20since%20it%20does%20not%20have%20the%20value%20101.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530516%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530516%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3E%26nbsp%3BHi!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EDid%20you%20take%20a%20look%20at%20the%20image%20%221.png%22%20i%20attached%3F%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20formula%20can%20work%20correctly%2C%20either%20if%20i%20decide%20to%20include%20the%20headers%2C%20or%20not%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBecause%20I%20read%20a%20web%20page%20in%20spanish%20(because%20that%20is%20my%20native%20language)%2C%20in%20which%20the%20person%20explained%20that%20the%20VLOOKUP%20formula%20CANNOT%20include%20the%20headers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20it%20was%20after%20reading%20that%2C%20that%20i%20was%20no%20longer%20sure%20if%20the%20formula%20could%20work%20correctly%2C%20either%20if%20i%20decided%20to%20include%20the%20headers%2C%20or%20not.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20you%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530520%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530520%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675152%22%20target%3D%22_blank%22%3E%40JMB17%3C%2FA%3E%26nbsp%3BHi!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EDid%20you%20take%20a%20look%20at%20the%20image%20%221.png%22%20i%20attached%3F%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20formula%20can%20work%20correctly%2C%20either%20if%20i%20decide%20to%20include%20the%20headers%2C%20or%20not%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBecause%20I%20read%20a%20web%20page%20in%20spanish%20(because%20that%20is%20my%20native%20language)%2C%20in%20which%20the%20person%20explained%20that%20the%20VLOOKUP%20formula%20CANNOT%20include%20the%20headers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20it%20was%20after%20reading%20that%2C%20that%20i%20was%20no%20longer%20sure%20if%20the%20formula%20could%20work%20correctly%2C%20either%20if%20i%20decided%20to%20include%20the%20headers%2C%20or%20not.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20you%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530527%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530527%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675152%22%20target%3D%22_blank%22%3E%40JMB17%3C%2FA%3E%26nbsp%3BHi!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EDid%20you%20take%20a%20look%20at%20the%20image%20%221.png%22%20i%20attached%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20formula%20can%20work%20correctly%2C%20either%20if%20i%20decide%20to%20include%20the%20headers%2C%20or%20not%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBecause%20I%20read%20a%20web%20page%20in%20spanish%20(because%20that%20is%20my%20native%20language)%2C%20in%20which%20the%20person%20explained%20that%20the%20VLOOKUP%20formula%20CANNOT%20include%20the%20headers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20it%20was%20after%20reading%20that%2C%20that%20i%20was%20no%20longer%20sure%20if%20the%20formula%20could%20work%20correctly%2C%20either%20if%20i%20decided%20to%20include%20the%20headers%2C%20or%20not.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20probably%20the%20person%20of%20that%20web%20page%20was%20just%20speaking%20carelessly%20without%20knowing%20what%20he%20was%20saying.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20you%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530534%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530534%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F726406%22%20target%3D%22_blank%22%3E%40Miguel_Zafiro%3C%2FA%3E%26nbsp%3B%2C%20Correct%2C%20it%20will%20work%20either%20way.%20Can%20you%20post%20the%20link%20to%20the%20page%20where%20you%20read%20that%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20always%20test%20if%20this%20is%20true%20or%20not%20by%20including%20and%20excluding%20the%20headers%20and%20see%20if%20it%20makes%20a%20difference.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530529%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530529%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3E%26nbsp%3BHi!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EDid%20you%20take%20a%20look%20at%20the%20image%20%221.png%22%20i%20attached%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20formula%20can%20work%20correctly%2C%20either%20if%20i%20decide%20to%20include%20the%20headers%2C%20or%20not%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBecause%20I%20read%20a%20web%20page%20in%20spanish%20(because%20that%20is%20my%20native%20language)%2C%20in%20which%20the%20person%20explained%20that%20the%20VLOOKUP%20formula%20CANNOT%20include%20the%20headers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20it%20was%20after%20reading%20that%2C%20that%20i%20was%20no%20longer%20sure%20if%20the%20formula%20could%20work%20correctly%2C%20either%20if%20i%20decided%20to%20include%20the%20headers%2C%20or%20not.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20probably%20the%20person%20of%20that%20web%20page%20was%20just%20speaking%20carelessly%20without%20knowing%20what%20he%20was%20saying.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20you%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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.

9 Replies
Highlighted
Best Response confirmed by Miguel_Zafiro (Occasional Contributor)
Solution
You should be able to include the headers if you want.
Highlighted

@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. 

Highlighted

@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

Highlighted

@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

Highlighted

@Miguel_Zafiro , Correct, it will work either way. Can you post the link to the page where you read that? 

 

You can always test if this is true or not by including and excluding the headers and see if it makes a difference. 

Highlighted

@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. 

Highlighted

@TheAntony Hi!


I made a mistake, and i regret, but i cannot fix it.

 

I gave the best response to JMB17, but of a sudden I regretted, and i realized that the best response, in fact, should have been given to your response where you said

 

"@Miguel_Zafiro , Correct, it will work either way. Can you post the link to the page where you read that?

 

You can always test if this is true or not by including and excluding the headers and see if it makes a difference."

 

Please forgive me, that response of yours was in fact the best response, please forgive me, i did not take a wise decision.


I am afraid of giving you the link to the web page where that person explained not to include the headers in the VLOOKUP function, because i dont want that person (or that webpage, which is very useful to many people because it explains many many things of excel in a very useful way), to be harmed, sorry.

 

I followed your advice, i made experiments with VLOOKUP function, using the headers, and not using them, and functions perfectly either way.

 

Thanks, your help was very useful theantony, and please forgive me again for not giving the best response, to you, i feel really bad, you was the one who was replying to my replies, and not jmb17.

 

But i am going to ask another question related to the VLOOKUP function, i will try to send you the link, maybe you can help me again, and maybe this time i give you the "best response".

 

Have a nice day.

 

Highlighted

@Miguel_Zafiro , It's all right. Don't worry about it. Have a great day.

Highlighted

@TheAntony Hi!

 

TheAntony, I posted a new question about the VLOOKUP formula.

 

I am sending you the link, in case you want to help me with that other question. Thanks.

Have a great day!

 

https://techcommunity.microsoft.com/t5/excel/vlookup/m-p/1533900#M69194