**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.*