Excel - How to Use a VLOOKUP Formula - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

When i do a VLOOKUP, I cannot autofill the formula for the rest of the table. It copies the initial cell that the VLOOKUP was done.
Solved by G. A. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 19/06/2018 - 08:10
more than 20
User 19/06/2018 - 08:10
Excelchat Expert 19/06/2018 - 08:10
Hello, I understand that you are having problems with your vlookup referencing, right?
User 19/06/2018 - 08:10
Excelchat Expert 19/06/2018 - 08:10
I see. We can help with this. Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.
Excelchat Expert 19/06/2018 - 08:11
Are you able to share your file so I can analyze it and let you know of the best possible solution?
User 19/06/2018 - 08:11
Excelchat Expert 19/06/2018 - 08:13
Still with me?
Excelchat Expert 19/06/2018 - 08:14
Are you there?
Excelchat Expert 19/06/2018 - 08:15
Since you are not able to reply, I'll be giving you a solution based on how you've written the description but I can't guarantee that it is what will solve your problem.
Excelchat Expert 19/06/2018 - 08:15
Based on how you've written the issue, it appears that your VLOOKUP() formula may be using absolute referencing.
Excelchat Expert 19/06/2018 - 08:16
You'll know that it is the case if your range (cells) are written with the $ sign.
Excelchat Expert 19/06/2018 - 08:16
For instance $A$1 means that wherever you paste the vlookup, it will always be referencing $A$1.
Excelchat Expert 19/06/2018 - 08:17
While A1 when pasted one column to the right will automatically adjust itself to B1. And when pasted 1 row down will be A2 automatically.
Excelchat Expert 19/06/2018 - 08:17
So if you can just remove the $ in the referencing of your vlookup, you can then try to paste it to another cell and see if that's the result you need.
Excelchat Expert 19/06/2018 - 08:18
I would love to see your actual file so I can provide you with the exact formula you need but since you have stopped replying, I won't be able to.
Excelchat Expert 19/06/2018 - 08:18
Hi, I have not received a reply from you for quite some time. I'm afraid the session will end automatically soon. I sincerely hope we were able to address your concern.

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc