Forum Discussion
VLOOKUP FORMULA
- Jul 17, 2020You should be able to include the headers if you want.
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.
Miguel_Zafiro , It's all right. 🙂 Don't worry about it. Have a great day.
- Miguel_ZafiroJul 20, 2020Copper Contributor
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