Excel - How to Use a VLOOKUP Formula - Expert Solution

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

Please insert a formula into column D that brings the code from Column H into Column D, using VIN in column I as the look up factor. I think this is a vlookup function but I am struggling
Solved by C. A. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 10/02/2018 - 03:11
hi welcome at got it pro
Excelchat Expert 10/02/2018 - 03:12
hello are you there?
User 10/02/2018 - 03:12
yes
User 10/02/2018 - 03:12
I am going to copy and paste in the table
Excelchat Expert 10/02/2018 - 03:12
yes please
User 10/02/2018 - 03:14
It won't allow me to copy it in
Excelchat Expert 10/02/2018 - 03:14
can you share your data sheet?
User 10/02/2018 - 03:14
It is nine columns across.
User 10/02/2018 - 03:15
I don't think so.
User 10/02/2018 - 03:15
It is part of an application. I am just stuck on this vlookup
Excelchat Expert 10/02/2018 - 03:15
can i give any example of vlookup to shared sheet/?
User 10/02/2018 - 03:16
please insert a column formula into colum d that brings the dealer code from column h into column d, using VIN in column I as the look up factor
Excelchat Expert 10/02/2018 - 03:17
can you able to see the shered sheet?
User 10/02/2018 - 03:18
where it says 1,2,3 yes.
Excelchat Expert 10/02/2018 - 03:21
here lookup value must be arrived in the 1 column so that i switch the Deler code after the VIN column
Excelchat Expert 10/02/2018 - 03:22
hello i made the formula in shared sheet
Excelchat Expert 10/02/2018 - 03:22
please check it
User 10/02/2018 - 03:22
where do i see the formula
Excelchat Expert 10/02/2018 - 03:22
in cell D3
User 10/02/2018 - 03:23
there is nothing in D3 for me.
Excelchat Expert 10/02/2018 - 03:23
=VLOOKUP(C2,I:J,2,0)
Excelchat Expert 10/02/2018 - 03:24
can you able to see the shared sheet?
User 10/02/2018 - 03:24
yes
Excelchat Expert 10/02/2018 - 03:24
please check
User 10/02/2018 - 03:24
i still don't get it
User 10/02/2018 - 03:24
all i see is sheet 1.
Excelchat Expert 10/02/2018 - 03:25
yes
Excelchat Expert 10/02/2018 - 03:25
please change the value in cell C2 and cell D2 will automatically be changed
User 10/02/2018 - 03:26
sorry to say i am not at all following this.
Excelchat Expert 10/02/2018 - 03:27
please check this sheet
[Uploaded an Excel file]
Excelchat Expert 10/02/2018 - 03:27
i made it as per your requirement
User 10/02/2018 - 03:28
that sheet does not open
Excelchat Expert 10/02/2018 - 03:28
please download this file from TOP right side arriw
User 10/02/2018 - 03:30
I'm sorry i appreciate your help but this isnt working
User 10/02/2018 - 03:30
it won't open. i thought it was a more simple question
Excelchat Expert 10/02/2018 - 03:31
please check
[Uploaded an Excel file]
User 10/02/2018 - 03:31
Yes. I am looking at it.
Excelchat Expert 10/02/2018 - 03:32
yes please
User 10/02/2018 - 03:36
but it doesn't really help with my question/
Excelchat Expert 10/02/2018 - 03:37
but i gave you an example without original data how can i able to make formula...beause it is very cell by cell
Excelchat Expert 10/02/2018 - 03:39
if you share some dummy data or origional data then i can easily made this or you have any query with this formula then let me know

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.