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.