Need Little Help with Vlookup code

[nupur123]

Hi I have an excel file with 3 columns on sheet1 ("Name", "ID" and "Name Data"): "Name Data" is a blank column.

Name ID Name Data
Albert 4235
John 4237
Ramesh 4239
Micky 4241
Minnie 4243
Donalid 4245
Edited 4247
Goofy 4249

On sheet 2, there will be a similar ID column with only one ID: eg:
ID
4243

I want the vlooup code to match the ID value on sheet2 (in this eg, that would be "4243") with ID value on sheet 1 and copy The name associated with that ID to "Name data" of sheet1. The result should look like:

Name ID Name Data
Albert 4235
John 4237
Ramesh 4239
Micky 4241
Minnie 4243 Minnie
Donalid 4245
Edited 4247
Goofy 4249

Here is the code I have:

Please Login or Register  to view this content.

The only issue with this code is that it copies the name onto first cell under "Name data". Eg: it do the following:

Name ID Name Data
Albert 4235 Minnie
John 4237
Ramesh 4239
Micky 4241
Minnie 4243
Donalid 4245
Edited 4247
Goofy 4249

The minnie should get copied on 5th row under "Name data" and not on 1st row (excluding heading rows)

Can anyone please suggest me what to fix in the code?

Thanks a ton!

[Norie]

Where does 'Minnie' come from?

[visha_1984]

Hi,

nupur can u upload a sample sheet.

[nupur123]

Here is the attched file.

[Norie]

There's no data on Sheet2.

[nupur123]

Hi Norie,

Thanks for your reply.. I am sorry. there should be id, "4243" under Col "ID" on sheet2.

[nupur123]

Hi,

Here is the file again.

[nupur123]

Can anyone please reply? I would truly appreciate that.

[Norie]

I think you need to clarify a couple of things.

What are you looking up, where are you looking it up and what do you want to return

For example, do you want to return the name corresponding to the ID in A2 on Sheet2 to B2 on Sheet2?