Question description:
This user has given permission to use the problem statement for this
blog.
my vlookup doesn't work when I add a new column, is there a way to fix it?
Solved by B. H. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
12/12/2017 - 10:27
Hello! Welcome to Got It Pro-Excel.
Excelchat Expert
12/12/2017 - 10:29
Hi there
Excelchat Expert
12/12/2017 - 10:29
We're so glad to support you with your VLOOKUP formula today.
Excelchat Expert
12/12/2017 - 10:31
Well, when you added a new column that is related with getting values through VLOOKUP, yes, there's a way to fix it still
Excelchat Expert
12/12/2017 - 10:32
Your Vlookup formula must be updated too because getting the values always depends on which column you want to adapt
Excelchat Expert
12/12/2017 - 10:35
In figuring out your Vlookup formula, can you share your file with us to resolve this issue instantly?
Excelchat Expert
12/12/2017 - 10:35
We will be glad to support you at this session
Excelchat Expert
12/12/2017 - 10:36
How could we help you at this Vlookup issue
Excelchat Expert
12/12/2017 - 10:37
By the way, I may share you an additional information on how to use vlookup formula
Excelchat Expert
12/12/2017 - 10:37
The most important is, to follow the syntax o f vlookup
Excelchat Expert
12/12/2017 - 10:38
And the syntax of Vlookup looks like this,
Excelchat Expert
12/12/2017 - 10:38
VLOOKUP( value, table, index_number, [approximate_match] )
Excelchat Expert
12/12/2017 - 10:39
Wherein, value >> is to search for in the first column of the table.
Excelchat Expert
12/12/2017 - 10:39
Table >> will be two or more columns of data that is sorted in ascending order
User
12/12/2017 - 10:40
I know vlookup
User
12/12/2017 - 10:40
you don't have to teach me
Excelchat Expert
12/12/2017 - 10:40
great
Excelchat Expert
12/12/2017 - 10:40
So, how could I help you?
User
12/12/2017 - 10:40
and you are saying I have to fix column number everytime I insert a new column in table array?
Excelchat Expert
12/12/2017 - 10:40
Can you share your file with us, to fix your Vlookup?
User
12/12/2017 - 10:41
you are useless.
User
12/12/2017 - 10:41
I have stated what I want in problem description
Excelchat Expert
12/12/2017 - 10:41
Sorry dear, I haven't mentioned that.
Excelchat Expert
12/12/2017 - 10:41
Please, have you gone with other experts?
Excelchat Expert
12/12/2017 - 10:41
My apology, if you were disappointed
Excelchat Expert
12/12/2017 - 10:42
But please let us know how could we help you
Excelchat Expert
12/12/2017 - 10:42
We're so glad to have you and take your session in here
User
12/12/2017 - 10:42
it clearly says if "my vlookup doesn't work when I add a new column", what's workaround with it without having to manually change the column number.
User
12/12/2017 - 10:43
stop talking nonsese
User
12/12/2017 - 10:43
Do you know it or not?
Excelchat Expert
12/12/2017 - 10:43
My apology, just trying to reach you out
User
12/12/2017 - 10:43
what? are you serious?
Excelchat Expert
12/12/2017 - 10:43
Since, we are in a session,
Excelchat Expert
12/12/2017 - 10:44
Oh yes, we love to support your excel issues the best we can based on your posted issue
User
12/12/2017 - 10:44
I'm talking about problem and you are talking gibberish. not a word related to the solution.
User
12/12/2017 - 10:45
get lost you moron you have no fucking clue on what you are doing.
Excelchat Expert
12/12/2017 - 10:45
I believe you understand our part, and our mission is to support every student comes in our sites
User
12/12/2017 - 10:47
haha you are really a joke.
User
12/12/2017 - 10:47
Still not a word on the solution.
Excelchat Expert
12/12/2017 - 10:47
Ohh, by the way, you were asking , if there's a way to fix your vlookup when you added a column. "my vlookup doesn't work when I add a new column, is there a way to fix it?"
Excelchat Expert
12/12/2017 - 10:48
My answer is "Yes"
Excelchat Expert
12/12/2017 - 10:48
Does it make sense?
User
12/12/2017 - 10:48
then talk about how
Excelchat Expert
12/12/2017 - 10:49
Now, at the vlookup formula you have, change the number column that is suited.
Excelchat Expert
12/12/2017 - 10:50
For example, it was set at 2 column, then change it into 3, if the location is found at the 3rd column
User
12/12/2017 - 10:50
there's no other way?
Excelchat Expert
12/12/2017 - 10:50
Got it?
Excelchat Expert
12/12/2017 - 10:51
The other way, when you add another column, be sure that it must be placed at the last column so that the number_column mentioned at the vlookup formula will not be change
User
12/12/2017 - 10:52
not the solution I'm looking for. I can already do that myself manually.
User
12/12/2017 - 10:52
Thanks for nothing.
Excelchat Expert
12/12/2017 - 10:53
Ohh, my apology. Still thankful of knowing your thoughts
Excelchat Expert
12/12/2017 - 10:54
Surely, that method you have will be resolved.
User
12/12/2017 - 10:54
There should be a automatic workaround. I'm sure I'll figure it out.
Excelchat Expert
12/12/2017 - 10:55
I will be glad you have. However, I will be grateful if you can share with us, so we could help you
Excelchat Expert
12/12/2017 - 10:59
Anyway, how can we help you regarding this topic, though
Excelchat Expert
12/12/2017 - 11:04
By the way, thank you for your time and effort coming at Got It Pro-Excel!
Excelchat Expert
12/12/2017 - 11:04
For any other Excel issues, please don't hesitate to come again. We will be glad to support you anytime.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
